Linking 2 Excel Spreadsheets on Power BI

[Eghaghara]

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

[Greg_Deckler · Accepted solution]

Yes, you could either import both spreadsheets and then relate them to one another or do a Merge query in Power Query.

[Greg_Deckler · Accepted solution]

Yes, you could either import both spreadsheets and then relate them to one another or do a Merge query in Power Query.

[Eghaghara · Accepted solution]

Hi Greg,

Thank you very much for the solution.  It  worked.