Patrick shows how you can make one little change to your Power BI slicers to improve report performance. It's bananas!
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup157 2 Minute Tuesday: https://guyinacu.be/lineageview Q&A with Justyna: https://guyinacu.be/qandavisual LastDate in DAX: https://guyinacu.be/unexplaineddate Guy in a Cube courses: https://guyinacu.be/courses Sources Fiore’s Virtues of Business Intelligence (@SQLAllFather) Bad Practices In Power BI: A New Series & The Pie Chart Prologue (@gilra) [...]
Adam looks at why the LastDate DAX function is returning the wrong date within Power BI Desktop. Breaking down a twitter conversation. Twitter thread: https://twitter.com/dhawalmehta/status/1183750809646972929 Marco's Blog: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/ Reza's Blog: https://radacad.com/lost-customers-dax-calculation-for-power-bi Calendar Table: https://www.youtube.com/watch?v=gyvhM5eiT0U Reduce data model size: https://www.youtube.com/watch?v=c-ZqToc85Yc Sample download
Justyna joins us to show the new Q&A visual in Power BI Desktop. Easily ask a question and tune results in this awesome update. Connect with Justyna: Twitter: https://twitter.com/JustynaLucznik
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!
Phil sits down with us to walk through his process in debugging a slow Power BI report. This uses some new features in Power BI Desktop as well as using DAX Studio to get further insights. Connect with Phil Twitter: https://twitter.com/PhilSeamark Blog: https://dax.tips/
Patrick shows you how to get rid of the pie chart in Power BI Desktop. Finally a way to remove the temptation! The ability to customize the visual pane in Power BI Desktop lets you do it.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup155 2 Minute Tuesday: https://guyinacu.be/querydependency Patrick's tech video: https://guyinacu.be/customformatstrings Adam's tech video: https://guyinacu.be/dataflowsgateway Sources A comprehensive guide to Power BI performance tuning (@SQLGene) Grouping with Style (@PowerBITips) Congratulations to the Winners of the “Back to School” Contest! Template apps update [...]