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,
I have a fact table that refers to about 30 of a dimension table's 100 keys. What is best practice to only load dimension table keys that are in the fact table?
I can get what I want by
* referencing the (VERY LARGE) fact table
* removing all columns but the foregin key column
* removing duplicates
* merging (inner join) with the dimension table
I was thinking there has to be a less expensive way than this though. It would be nice to not have all the unnecessary dimension table data.
Thanks!
Solved! Go to Solution.
Use Power Query and Query folding to pre-filter your data, or do that in your data source.
NOTE: yes, you should reduce the amount of data you load into Power BI as early as possible, but not earlier. Take some time to consider if you are destroying information by applying this filter.
Use Power Query and Query folding to pre-filter your data, or do that in your data source.
NOTE: yes, you should reduce the amount of data you load into Power BI as early as possible, but not earlier. Take some time to consider if you are destroying information by applying this filter.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |