Category: Power Query

VLOOKUP Into “Vendor – URL” With TEXTBEFORE – 2486

Posted on by Annie D

Today’s Excel question from Willie at the UCF Accounting Conference:
I am using a vlookup to get some information from a vendor info database that comes from the credit card website.
 
My issue is that the vendor name sometimes comes with additional info at the end like …. “Contoso – cadet.biz” and in the table where I do the lookup the name is just “Contoso”.
 
I was wondering if you think I can use the “TEXTBEFORE” function with the Vlookup formula to make the formula to look in the table only for the first word of the info coming from the credit Continue reading “VLOOKUP Into “Vendor – URL” With TEXTBEFORE – 2486″ →

How do you share your Power BI Dataset for someone to review?

Posted on by Annie D

Need to have someone review your Power BI dataset for best practices and approval? Don’t want to send them the full Power BI Desktop file and risk sharing data? Patrick walks you through some options that you have.

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— rel=”nofollow”>https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Dataset #GuyInACube

🔴 Power BI tips from the Pros – LIVE (May 14, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (May 14, 2022) (Member Chat 2nd Half)” →

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???

Posted on by Annie D

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion!

DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/

Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— Continue reading “Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???” →

How to make SQL Pools even faster in Azure Synapse Analytics

Posted on by Annie D

There are different ways you can get your SQL Pools to run faster in Azure Synapse Analytics. Patrick looks at a feature that can really take it to the next level! You seriously need to watch this if you are using Synapse dedicated SQL Pools.

Performance tuning with materialized views using dedicated SQL pool in Azure Synapse Analytics
https://docs.microsoft.com/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— <a Continue reading “How to make SQL Pools even faster in Azure Synapse Analytics” →

REPLAY Power BI tips from the Pros – LIVE (May 7, 2022)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “REPLAY Power BI tips from the Pros – LIVE (May 7, 2022)” →

EFFICIENT approach in Microsoft Teams for Power BI questions!

Posted on by Annie D

Using Microsoft Teams? Have a central place for your Power BI folks in your organization? This efficient approach will help you to get your question to the right people! At the same time cutting down the noise for other folks.

Steve Campbell
https://twitter.com/PowerBISteve
https://www.linkedin.com/in/powerbisteve/

Power BI Support Channel: Microsoft Teams Tips
https://powerbi.tips/2022/04/power-bi-support-channel-in-teams/

Power BI adoption roadmap
https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-adoption-roadmap-overview

Power BI implementation planning
https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-introduction

Manage tags in Microsoft Teams
https://docs.microsoft.com/en-us/microsoftteams/manage-tags

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help Continue reading “EFFICIENT approach in Microsoft Teams for Power BI questions!” →

My Excel file is in the cloud! Why isn’t refresh working in Power BI???

Posted on by Annie D

Pulling data from an Excel document in the cloud? Is your Power BI dataset not refreshing? Adam looks at why this could be the case and how to get it working.

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – Continue reading “My Excel file is in the cloud! Why isn’t refresh working in Power BI???” →

Why you should look at Azure Synapse Analytics!

Posted on by Annie D

Have you heard about Azure Synapse Analytics! Is your data in Synapse? It’s so much more than SQL Server! Adam and Patrick look at why you should care about it!

What is Azure Synapse Analytics?
https://docs.microsoft.com/azure/synapse-analytics/overview-what-is

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Continue reading “Why you should look at Azure Synapse Analytics!” →

Security Risk Microsoft Has Blocked Macros From Running – 2485

Posted on by Annie D

A new pink bar warning is appearing in Excel, Word, and PowerPoint telling you that there is a security risk and that your VBA macros have been blocked.
This warning is designed to make you ask, “Is there a valid reason for this person to be sending me a macro?” If there is, I will show you the easy steps to unblock the workbook.
This is called the Mark of the Web.
Kevin Lehrbass Word Game is here: https://www.myspreadsheetlab.com/word-game/

Table of Contents
(0:00) Kevin Lehrbass has a Wordle game in Excel but the macros are blocked with the pink bar.
(1:08) Continue reading “Security Risk Microsoft Has Blocked Macros From Running – 2485” →

REPLAY Power BI tips from the Pros – LIVE (Mar 26, 2022)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “REPLAY Power BI tips from the Pros – LIVE (Mar 26, 2022)” →

Row-Level Security and Object-Level Security together in Power BI??? Yup!

Posted on by Annie D

Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can’t be done? Think again! Patrick shows you how to use both together.

Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/

Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security

FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— Continue reading “Row-Level Security and Object-Level Security together in Power BI??? Yup!” →