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 Repo...
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.
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.