Forum Discussion
Solved
Linking 2 Excel Spreadsheets on Power BI
Hi,
I have got 2 spreadsheets (datasets) with a common theme betwen them, that is, a common column. Is Power BI able to connect to the 2 spreadsheets at the same time to show the data on one Report?
Thanks,
Abi
Yes, you could either import both spreadsheets and then relate them to one another or do a Merge query in Power Query.
Hi Greg,
Thank you very much for the solution. It worked.
2 Replies
Yes, you could either import both spreadsheets and then relate them to one another or do a Merge query in Power Query.
Hi Greg,
Thank you very much for the solution. It worked.