Forum Discussion

VitaliiCH17's avatar
VitaliiCH17
Frequent Visitor
3 years ago
Solved

Load dimensional data only for available fact data

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

Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    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 !

     

1 Reply

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    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 !