Sometimes you want to reduce data in Power BI Desktop so it's easier to work with. Then work with all the data in the Power BI Service. Patrick shows you 3 ways that can help do this without using Incremental Refresh or needing Power BI Premium!
If you need to change your data source references in Power Query, you are probably doing them individually. We found an INSANE AMAZING tip to make you way more efficient and it works in Power BI and Excel!
New to Power BI? Adam helps you get started with creating your first Power BI report in Power BI Desktop! Start your journey the right way! Guy in a Cube Blueprint Course: https://guyinacu.be/pbiblueprint Star Schema: https://docs.microsoft.com/power-bi/guidance/star-schema Star Schema Book: https://amzn.to/38JQJqq Definitive Guide to DAX: https://amzn.to/2MTIi3h Power BI Blog: https://blog.powerbi.com Power BI documentation: https://docs.microsoft.com/power-bi Power BI [...]
Maybe you've heard of Power Query M in Microsoft Excel, Power BI or something else. Do you really need to be an expert in that? Or even use it? Patrick helps to ease your mind!
Have you noticed the updates Power BI dataflows has had recently? Patrick explores Visual Data Prep which helps you craft your transforms in Power Query Online. Blog: https://powerbi.microsoft.com/blog/announcing-visual-data-prep-public-preview-diagram-view-in-power-query/
It's really frustrating when your Power BI refresh takes too long or times out! Adam breaks down 3 bottlenecks that can slow down your Power BI refresh to help you optimize the performance.
Showing off 3 HIDDEN tricks in the Power Query editor, in Power BI and Excel, that you may not have known about. Little things that take Power Query to the NEXT LEVEL!
Thanks for watching this week's Power BI news roundup! 2 Minute Tuesday: https://guyinacu.be/userprincipalname Tech video: https://guyinacu.be/whatisrls 📢 Become a member: https://guyinacu.be/membership Sources Why Is Power BI Running My SQL Query Twice? (@cwebb_bi) Analyzing Performance Analyzer trace in DAX Studio (@marcorus) The ultimate button resource for Power BI by Tableau Zen Masters (@curbalen) [...]
Have you wondered how to get a refresh date in your Power BI report? Adam looks at an easy way to do that with a little Power Query.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup181 2 Minute Tuesday: https://guyinacu.be/dataflowstricks Patrick's tech video: https://guyinacu.be/synapse Adam's tech video: https://guyinacu.be/pipelines 🔴 Live replay: https://guyinacu.be/live013 📢 Become a member: https://guyinacu.be/membership Sources #3 DAX Fridays! 101: What is Context transition in DAX? (@CurbalEN) How To Mask Sensitive Data In [...]