Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup179 2 Minute Tuesday: https://guyinacu.be/copyquery Patrick's tech video: https://guyinacu.be/datepicker Adam's tech video: https://guyinacu.be/matrixkpis 🔴 Live Replay: https://guyinacu.be/35WURjU 📢 Become a member: https://guyinacu.be/membership Sources Speed Up Data Refresh Performance In Power BI Desktop Using Table.View (@cwebb_bi) Part 3: Reflections on 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...
Are you trying to use Power BI dataflows, but your data source isn't listed? We show you an option you can try to get things running!
Enough of these single table models! Model your data and create custom keys within Power BI to make your reports more efficient! Download Sample
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 [...]
We look at how to tell if query folding is actually happening within Power BI. You may be surprised! Power Query has a few tools for you. Download sample
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup156 2 Minute Tuesday: https://guyinacu.be/easyparameters Patrick's tech video: https://guyinacu.be/referencequeries Interview: https://guyinacu.be/powerbiqueen Guy in a Cube courses: https://guyinacu.be/courses Sources Power Query – Function to Execute an SQL Procedure (@Laura_GB) Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI [...]
Chris Webb joins Patrick to look at what happens when you use reference queries for Power Query. This applies to both Power BI and Excel. Chris also looks at how change the behavior to make things a bit faster. Data Privacy Blog: https://blog.crossjoin.co.uk/2018/12/27/data-privacy-settings-data-refresh-performance-power-bi-excel/ Connect with Chris Webb: Twitter: https://twitter.com/cwebb_bi Blog: https://blog.crossjoin.co.uk/
Patrick shows how you can easily use parameters, for your data source, within Power BI Desktop with minimal clicks. All about reducing the clicks!
Patrick shows how you can see query dependencies within Power Query in Power BI Desktop.