Forum Discussion
How to avoid loading dimensions that not exist in the fact table
Hi Anonymous ,
According to my understand, you want to keep rows in Dimension table matched from Fact table.
You could select Dimension table --> use Merge-->Right Outer-->Remove unnecessary columns as shown below:
If the data is continuous, you could add the whole column in Fact table as new Query ,then use it to create a parameter to filter the column in Dimension like this:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You would disable the load of these tables in the Query Editor
Right click on the tables you do not wish to load and uncheck the enable load.
Performance Tip for Power BI; Enable Load Sucks Memory Up - RADACAD
I must load the dimensions that exists in the fact table.
Have you understand my Q correct?
Hi,
apologies, I didn't understand your question correctly.
Can you explain a bit further please?
As you see in the picture
pk_installations 50-100 not needed for filtering the fact table.
I don't want them to be loaded to the dataset.
In the real tables I have 3million of rows in the dim table, but I have incidents on maybe 1 miljon of the dimension rows.
So 2 million of dim rows not needed. Will take time to load and will consume memory.Anonymous you can also make use of native query(SQL)
in power bi as well..What is your data source?