Forum Discussion
Selecting between slowing changing dimension effective dates is very slow
Hello, In a dimension table of 4 million records in my Power BI file using import mode, I have slowly changing rows for customer attributes that looks like this: The date columns are actuall...
PaulOlding
Solution Sage
Solution SageCan you share the real data (perhaps anonymised)?
I tried to recreate the issue by creating 100k rows of random data but I don't get the same query plan
Thanks for your reply! Unfortunately I am prohibited from doing so, which I realize may make it difficult for others to help. At the moment I'm down the path of the suggestions here:
https://www.sqlbi.com/whitepapers/understanding-dax-query-plans/