Patrick looks at how you can use DAX Studio, or SQL Profiler, to do query profiling on Power BI Premium. This can help you debug query performance and more.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup150 2 Minute Tuesday: https://guyinacu.be/connecttools Patrick's tech video: https://guyinacu.be/powerapps Adam's tech video: https://guyinacu.be/reducedatasetsize Sources Chart With Different Scales (@dagdooe) Blank row in DAX (@FerrariAlberto) What’s new for SQL Server 2019 Analysis Services RC1 Change to Summarized Data Export behavior with [...]
Adam shows you two things to reduce your Power BI dataset size. These are both things he commonly sees with Power BI reports and could potentially save you a lot of space and improve refresh times along with report performance. Data reduction techniques for import modeling
Patrick takes a look at how you can integrate PowerApps with Power BI to get a bananas experience. Updating the PowerApp does something special with the Power BI report. Create a PowerApp: https://docs.microsoft.com/powerapps/maker/ PowerApps custom visual: https://docs.microsoft.com/powerapps/maker/canvas-apps/powerapps-custom-visual
Adam shows you how to connect to Power BI Desktop using 3rd party tools such as DAX Studio. This is a great way to perform optimization to your data model.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup149 Tech video: https://guyinacu.be/columnfromexample Atlanta Training in October 2019: https://guyinacu.be/trainingatl2019 Sources Replacing Analysis Services with Power BI shared datasets (@fhedenstrom) Power BI gets five new settings to tackle capacity-related issues (@HamzaJawad98) Understand a star schema and the importance for Power [...]
Patrick is going bananas with these different ways that Column from Examples can help you shape your data without writing code in Power BI. This feature really helps you to be efficient! Download sample Want to download the sample report? Hit the download button below.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup148 Tech Video: https://guyinacu.be/hierarchy Upcoming Training Create and distribute Power BI reports for beginners – Atlanta – October 2019 Sources Dynamic Visuals using Buttons (@PowerBITips) Conditional Formatting for Single Value Cards (@HavensBI) DAX Fusion (@Phil_Seamark) Connecting Azure Analysis [...]
Patrick looks at how to create and use a Power BI Hierarchy within Power BI Desktop. Hierarchies can help to provide correct data usage within your Power BI reports. Download sample Want to download the sample report? Hit the download button below.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup147 Tech video: https://guyinacu.be/sirishortcuts Sources Differences between Power BI Apps and Workspaces (@CurbalEN) Why Power BI Shared Datasets are Critical to a Self-Service BI Implementation (@sqlchick) Microsoft a Leader in The Forrester Wave™: Enterprise BI Platforms Power BI Developer community [...]