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!
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!
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup191 Patrick's tech video: https://guyinacu.be/dynamictitle Adam's tech video: https://guyinacu.be/onecheckbox 🔴 Live Replay: https://guyinacu.be/live023 📢 Become a member: https://guyinacu.be/membership Sources #POWERBI BUTTONS WITH ANIMATION (@pkamasani) Power BI - Visual Pagination (@PowerBIElite) Distinct Count in Power BI (@Rad_Reza & @PhilSeamark) Simplifying enterprise [...]
DAX Studio is an awesome tool! You can even use it to trace Power Pivot within Excel. Patrick shows you how!
Take your Power Pivot model in Excel and easily convert it to Power BI in just a few steps. Patrick looks at a few different ways to do this.
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!
Did you know you could copy queries, in Power Query, between Power BI or Excel files? Even Notepad? Patrick shows you how, and more...
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup164 2 Minute Tuesday: https://guyinacu.be/qandatooling Patrick's tech video: https://guyinacu.be/copyreports Adam's tech video: https://guyinacu.be/pbiworkemail Sources Easily Build Great User Experiences In Power BI (Chris Wagner) GET STARTED WITH POWER BI (@marqueeinsights) Dual Axis Line Chart in Power BI (@ExceleratorBI) 6 DAX [...]
Adam looks at the different ways you can use Microsoft Excel with Power BI. So many choices!
In this video, Marco Russo, from SQL BI, joins Patrick to look at how you can debug DAX using variables in Power BI. Marco helps to break down a DAX measure and show how you can see the results as you build it up to find where the problem is. SQL BI DAX Formatter DAX [...]