Patrick shows you how you can clear the Power BI Desktop model cache when troubleshooting DAX performance.
About pleblancThis author has not yet filled in any details.
So far pleblanc has created 52 blog entries.
Patrick continues the journey of data modeling best practices with looking at where to create your columns within Power BI. In the data source, in Power Query or using a DAX calculated column? High Memory Usage and Calculated Columns (@tlachev) VertiPaq Analyzer (Free)
Patrick shows you how easy it is to use Microsoft Flow to take Power BI data alerts to the next level. Use Microsoft Flow to send to additional people.
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.
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
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.
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.
Patrick shows you how to create Siri shortcuts with the Power BI Mobile iOS app. This can be a great way to access your Power BI reports quickly. Documentation: https://docs.microsoft.com/power-bi/consumer/mobile/mobile-apps-ios-siri-shortcuts
Patrick breaks down how detect data changes works with Power BI Incremental Refresh. He demystifies some common misunderstandings when using this setting in Power BI Premium. Incremental refresh documentation - https://docs.microsoft.com/power-bi/service-premium-incremental-refresh Getting started with Incremental Refresh in Power BI (video) - https://www.youtube.com/watch?v=CajQjq70Kpg Download the cheat-sheet Want to download the cheat-sheet? Hit the download button below. [...]