Multiple Fact table issue

[poojashribanger]

Hello All,

I am trying to migrate application from Qliksense to power bi where i have 4 fact tables with 5 identical column which i am concatenating in Qlik to get single fact table (i.e. Star schema).

How can i acheive this in power BI where i need same star schema with 1 central fact and surrounding dim.

each fact table has around 8lakh records.

Kindly help.

@PowerQuery

Thanks & Regards,

Poojashri

[HopkiJ]

Hi Poojashri

This video from Guy in a Cube may be able to help you. 

Guy in a Cube 

However, if you want to create one large table (don't recommend) then merging your tables into one query would do it. 

[BA_Pete · Accepted solution]

Hi Poojashri,

Do you mean 'Append' when you say "concatenate"?

If so then select one of your fact tables in Power Query then go to the Home tab > Append Queries (dropdown) > Append Queries As New.

Once in the Append dialog, select the 'Three or more tables' radio button, then Add all the tables to the right-hand box that you want to append together.

Pete