Adam look at Power BI build permissions with shared datasets. Taking the mystery out of how you can interact with datasets and know what to do if you can't use it. This also looks at how Power BI free users can use shared datasets with Power BI Premium.
Patrick looks at a few data modeling best practices in Power BI and Analysis Services. These are things we see customers doing on a regular basis and you should be aware of it.
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 [...]