Frustrated that a you can only do a full refresh? Patrick takes it to the next level by showing how you can refresh only a single table in your Power BI dataset. This is a great option for targeted refresh Continue reading “Can you refresh a single table in Power BI?”
Category: Power Query
One Click Calculation Group in Power BI
Calculation Groups in Power BI can be amazing! Patrick shows you how you can create these common patterns with just one click using Tabular Editor.
Blog:
https://www.esbrina-ba.com/time-intelligence-the-smart-way/
Calculation Groups:
https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions
Tabular Editor:
https://tabulareditor.com
📢 Become a member: <a Continue reading “One Click Calculation Group in Power BI”
How to show a name more than once in Power BI
Ever run into an issue where a duplicate name doesn’t show up? Is it being aggregated? Patrick looks at a few ways you can avoid the duplicate name from disappearing in Power BI.
📢 Become a member: https://guyinacu.be/membership Continue reading “How to show a name more than once in Power BI”
Power BI XMLA Endpoint: Why you should care
The XMLA Endpoint in Power BI can be very powerful. Adam looks at what it is and how to get started with it. If you are using Power BI Premium or Premium Per User, you need to know about this!
Live Continue reading “Power BI XMLA Endpoint: Why you should care”
When is a date not a date in Power BI?
When is a date not a date? We all use them in our data. Patrick looks at how data types can be a tricky thing in Power BI. Be aware of what you are working with in order to avoid Continue reading “When is a date not a date in Power BI?”
Case of the SLOW Power BI report: Hierarchies and RLS
Using a parent/child hierarchy? Check out how we diagnose performance when using some of the PATH DAX functions in Power BI and also how to make this report faster!
PATHCONTAINS Reference:
https://dax.guide/pathcontains/
📢 Become a member: https://guyinacu.be/membership Continue reading “Case of the SLOW Power BI report: Hierarchies and RLS”
What are Power BI data connectors and why should you care?
You need a connector to work with data in Power Query for Power BI or Excel. But what is a connector? Adam explains what these are and how to find out what’s available.
Power Query Connectors:
https://docs.microsoft.com/power-query/connectors/
Power BI data Continue reading “What are Power BI data connectors and why should you care?”
How to show 5 minute intervals in Power BI?
Another question from the comments… MrTavelBlog wanted to know how to show 5 minute intervals in Power BI. Patrick accepts the challenge and shows you how!
Power BI date table: create using DAX
https://www.youtube.com/watch?v=gyvhM5eiT0U
Working with time in Power Continue reading “How to show 5 minute intervals in Power BI?”
Power Query! Uggg – Where do you start? | Power BI
Not a coder? Don’t understand Power Query M syntax? Power Query can be fun, but also can turn complicated. Learning Power Query can make Power BI and Excel very rewarding. Adam has some resources to get you started in your Continue reading “Power Query! Uggg – Where do you start? | Power BI”
Finding the lowest value and highlighting in DAX | Power BI
Sometimes you want to highlight the lowest value in a Power BI visual. First you need to find it! Then you can highlight it. What if you want to ANIMATE it? Patrick shows you how to do just that!
ALLSELECTED() article: Continue reading “Finding the lowest value and highlighting in DAX | Power BI”
DAX! Uggg – Where do you start? | Power BI
Not a coder? Don’t understand DAX syntax? DAX can be intimidating and difficult to learn. Frustrating even! Learning DAX can make Power BI very rewarding. Adam has some resources to get you started in your journey.
Beginning the journey:
MS Learn: User Continue reading “DAX! Uggg – Where do you start? | Power BI”
The Power BI Premium video you need to watch… probably (Oct 2021)
There has been a lot of recent news about Power BI Premium. Adam looks at what Gen2 is all about along with timelines to keep in mind. A MUST watch… probably.
What is Power BI Premium Gen2:
https://docs.microsoft.com/power-bi/admin/service-premium-gen2-what-is
Power BI Continue reading “The Power BI Premium video you need to watch… probably (Oct 2021)”