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.