Load dimensional data only for available fact data

[VitaliiCH17]

Hi,

I'm new to PowerBI. I'm working on an application that has a star schema data model. 

In the facts table I reduce the number of rows by filtering data by year, right now I'm loading only the last three years of data.

I would like to reduce the size of the dimensions tables - just loading data for existing facts. 

Is it possible to reduce data in the dimension table? I guess it should be something equivalent to left join without merging tables

Regards,

Vitalii

[serpiva64 · Accepted solution]

Hi,

take a look at attached file. I merged Dimension right outer

and then removed the merged column of tables in Dimension.

If this post is useful to help you to solve your issue consider giving the post a thumbs up  and accepting it as a solution !