Combine/Merge multiple Data sources

[Yarisch77]

Hi everyone,

I am struggeling with the follwoing issue:

I have 3 Data sources with identical column names but different data which I want to display in an output field with corresponding relations in Power BI:

This looks like that:

Data sources

Different Column names

After that I want to create a table which can diplay corresponding data from all data sources:

Also important is, that I can display different relations inside this table when I click other charts. I ve tried Combine data sources with full outer join but did not get any data inside the new created table.

Do u have an idea how to solve this?

Thx in advance!!!

[V-pazhen-msft · Accepted solution]

@Yarisch77

I don't have much detail of your situation but combine the tables should work using merge and append features in Query Editor, retry it: https://www.excelinppc.com/merge-vs-append-in-power-bi-in-power-query-editor/

Or if you are connecting to 3 excel/csv files, I would suggest you to try get data from folder step by step:: https://radacad.com/power-bi-get-data-from-multiple-files-in-a-folder-on-onedrive-for-business-no-ga... .

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[venal]

@Yarisch77 

Please drag and drop few columsn to the visual (table visual for example) and let us know if you have any queries.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR,

venal.