SCD Type 4 - Power BI Model

Question

Hi,

 

I have implemented SCD Type 4 and loaded data in 2 diff tables, live and history. WE have lots of tables and all of them are implemented with tpe 4. and we will definitely have many-many relationships when we model this in power bi.

As we maintain data datewise, there will be duplicates in the certain columns. For eg I have  a header column which is duplicated bec of type 4 implementation. We can identify the unique records only with the combination of header and recorddate. 

Business requirement is to select the recorddate in the report and they should be able to see the data for that particular date.

how can I model in power bi, how to get rid of man-many issue?

 

Answer 1

Hi @Santhi Dhanuskodi

Thank you for confirming!

Based on your query, this is related to Power BI modeling and handling SCD Type 4 relationships in Power BI.

Currently, Power BI is not supported in Microsoft Q&A forums, and we recommend posting your query in the Power BI Community Forum, where Power BI experts can assist you better:

Power BI Community Forum: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi

For a list of supported products on Microsoft Q&A, you can refer to this page: Supported products on Microsoft Q&A.

Hope this helps. Do let us know if you any further queries.