Multiple Data Sources into one fact table

[ps_]

Hello. I have 5 files from different project sites but all have the same headers. Is it possible for me to use all 5 excel files as datasources for one fact table? Thanks

[Ashish_Mathur · Accepted solution]

Hi,

Append those files into a single table by following the technique shown in this video -Append.

[PhilipTreacy · Accepted solution]

Hi @ps_ 

Yes, when you import them to PBI choose to Append the files.

Phil

[Ashish_Mathur · Accepted solution]

Hi,

Append those files into a single table by following the technique shown in this video -Append.