Forum Discussion
Set multiple data sources from 2 Excel spreadsheets
I have a Power BI report. I currently have 1 data source an Excel spreadsheet. Is it possible to setup a 2nd data source being a 2nd Excel spreadsheet to the powerbi report. Therefore 2 datasources as 2 seperate different Excel spreadsheets feed data to the powerbi report.
TIA
Hi dd88 ,
Yes, you can definitely set up multiple data sources in Power BI, including using two separate Excel spreadsheets.
Once both data sources are loaded, you can manage and transform the data using Power Query Editor. Here’s a brief overview of what you can do next:
- Combine Data: If you need to combine data from both sources, you can use the Merge Queries or Append Queries options in Power Query Editor.
- Create Relationships: If the data in the two spreadsheets are related, you can create relationships between tables in the Model view.
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
3 Replies
Hi dd88 ,
Yes, you can definitely set up multiple data sources in Power BI, including using two separate Excel spreadsheets.
Once both data sources are loaded, you can manage and transform the data using Power Query Editor. Here’s a brief overview of what you can do next:
- Combine Data: If you need to combine data from both sources, you can use the Merge Queries or Append Queries options in Power Query Editor.
- Create Relationships: If the data in the two spreadsheets are related, you can create relationships between tables in the Model view.
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
