cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Eghaghara New Member
New Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Linking 2 Excel Spreadsheets on Power BI

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

Re: Linking 2 Excel Spreadsheets on Power BI

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!