Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everyone,
I am working with Orders and OrderItems model. There are 6 different individual dimension keys that make up a primary key including a date field. To effectively use the filters I am using the linking table concept (Created a Primary key in the linking table via ETL and using that table to filter the facts).
Basically my model is like,
Orders <==> OrdersDimension <==> Rest of Dimensions
OrderItems <==> OrdersDimension <==> Rest of Dimensions.
/t5/image/serverpage/image-id/3095i6752181269DACC47/image-size/large?v=1.0&px=600
Works fine, but with historical data, I have more than 2Billion unique PK records via ETL which is a limitation in Tabular.
How can I get around this limitation?
I have tried another solution like linking the dimensions to the fact tables directly. but I have to write complex DAX to propagate filter conditions to OrderItems measures.
https://stackoverflow.com/questions/10181316/2-billion-distinct-values-per-column-limitation
Basically to solve a problem like this
https://community.powerbi.com/t5/Desktop/Best-Way-for-work-with-Multiple-Fact-Tables/td-p/21441
I saw an answer provided in this solution but I have no clue how to merge?
Any suggestions are appreciated. Thanks in advance.
Thank you @GilbertQ . At this moment that is one of the options I am considering. I am also trying to understand if there is any other work around for this situation meanwhile.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |