Do you have slowly changing dimensions in your Power BI dataset? Struggling to work with them to get the right values? Patrick walks you through how you can deal with them. Wikipedia https://en.wikipedia.org/wiki/Slowly_changing_dimension Using calculation groups to switch between different dates (SQLBI) https://www.youtube.com/watch?v=kilQrRR04mY P3 - https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/ Download Sample
About pleblancThis author has not yet filled in any details.
So far pleblanc has created 141 blog entries.
You've got multiple fact tables in your Power BI dataset. And, dimension tables for each. Struggling to slice and dice across both? Patrick shows you how to deal with this mess. Understand star schema and the importance for Power BI https://docs.microsoft.com/power-bi/guidance/star-schema
Is the full refresh of Incremental Refresh taking a long time? Or, even timing out? Patrick shows you how you can avoid the full refresh and refresh each partition individually when using Power BI Premium! Handling deletes within Incremental Refresh in Power BI: https://www.youtube.com/watch?v=nKVrl0ec6uE SQL Server Management Studio: https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 ALM Toolkit: http://alm-toolkit.com/ XMLA Endpoint: https://docs.microsoft.com/power-bi/admin/service-premium-connect-tools
Maybe you've heard of Power Query M in Microsoft Excel, Power BI or something else. Do you really need to be an expert in that? Or even use it? Patrick helps to ease your mind!
Not sure what Power BI Paginated Reports are or how to use them? Patrick walks you through and points you to some great resources to get up and running quickly. Power BI Paginated Reports require either Power BI Premium Per User or Power BI Premium capacity. References Paginated Report In a Day Training Paginated Samples [...]
Are your paginated reports still on-premises with either Power BI Report Server or SQL Server Reporting Services? Want to move them to Power BI? Patrick shows you how you can do that using the RDLMigration tool! Documentation: https://docs.microsoft.com/power-bi/guidance/migrate-ssrs-reports-to-power-bi RDLMigration Tool on GitHub https://github.com/microsoft/RdlMigration GitHub release page https://github.com/microsoft/RdlMigration/releases App Registration https://dev.powerbi.com/apps
Are you using Incremental Refresh in Power BI? Are you stuck with how to handle deletes? Patrick has a great technique you can use to not only handle deletes, but also more easily handle updates with your partitions. Download Sample
You may be able to write a DAX expression, but what about an actual DAX query? DAX queries can help you validate data and fine tune your DAX expressions used for Power BI. Patrick shows you how!
Have you noticed the updates Power BI dataflows has had recently? Patrick explores Visual Data Prep which helps you craft your transforms in Power Query Online. Blog: https://powerbi.microsoft.com/blog/announcing-visual-data-prep-public-preview-diagram-view-in-power-query/
Too many rows? How is that possible? Patrick looks at a case where a customer hit an error of too many rows coming back from a DAX statement in Power BI.