fbpx

About pleblanc

This author has not yet filled in any details.
So far pleblanc has created 141 blog entries.

Working with Slowly Changing Dimensions in Power BI

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

Working with Slowly Changing Dimensions in Power BI2021-02-17T05:43:50-05:00

Handling MULTIPLE fact tables in Power BI

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

Handling MULTIPLE fact tables in Power BI2021-02-10T07:43:45-05:00

Avoid the full refresh with Incremental Refresh in Power BI (Premium)

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

Avoid the full refresh with Incremental Refresh in Power BI (Premium)2021-01-27T07:34:27-05:00

Do I need to be an expert in Power Query M?

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!

Do I need to be an expert in Power Query M?2021-01-20T07:01:42-05:00

Getting started with Power BI Paginated Reports (2021)

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 [...]

Getting started with Power BI Paginated Reports (2021)2021-01-13T08:02:05-05:00

Migrate your Paginated reports to Power BI

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

Migrate your Paginated reports to Power BI2021-01-06T08:01:31-05:00

Handling deletes within Incremental Refresh in Power BI

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

Handling deletes within Incremental Refresh in Power BI2020-12-09T07:26:18-05:00

A look at Visual Data Prep in Power BI dataflows

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/

A look at Visual Data Prep in Power BI dataflows2020-11-26T07:48:23-05:00

Power BI Case: Too many rows from a DAX Statement

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.

Power BI Case: Too many rows from a DAX Statement2020-11-25T10:04:30-05:00
Go to Top