Trace Excel Power Pivot using DAX Studio
DAX Studio is an awesome tool! You can even use it to trace Power Pivot within Excel. Patrick shows you how!
Easily convert your Excel Power Pivot model to Power BI
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.
3 HIDDEN tricks in the Power Query editor for Power BI and Excel
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!
Copy queries in Power Query for Power BI or Excel
Did you know you could copy queries, in Power Query, between Power BI or Excel files? Even Notepad? Patrick shows you how, and more...
Do you know what a Power BI seed file is??? (Roundup | Jan 27, 2020)
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 [...]
Different ways to work with Microsoft Excel in Power BI
Adam looks at the different ways you can use Microsoft Excel with Power BI. So many choices!
Debug DAX using Variables in Power BI
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 [...]
Power BI, Excel, USAFacts and more… (April 19, 2018)
Compound Growth using DAX (@ExceleratorBI) Power BI and Excel; More than just an Integration (@Rad_Reza) Drill Down & Up in Power BI Mobile apps Join the Power BI team at Microsoft Build USAFacts breaks down government financial data with Power BI BONUS ITEMS: DAX Best Practices (@marcorus) DAX Optimization Examples (@marcorus) Reordering Multiple Columns With [...]
Use a KPI in a table within Power BI
In this video, Adam shows you how you can import KPIs from Excel into Power BI. Once in Power BI, you can use the KPI in a table or matrix. Documentation: Import and display KPIs in Power BI
Ragged Hierarchies in Analysis Services with Power BI and Excel
In this video, Patrick looks at the ragged hierarchy problem within Excel and Power BI when you are pulling data from Analysis Services. He looks at how you can correct the issue easily within Excel and some alternatives for Power BI.