Forum Discussion
Post PatronSet multiple data sources from 2 Excel spreadsheets
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
Super UserHi 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