Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.