Forum Discussion
abpgupta
Continued Contributor
3 years agoConnect multiple Datasets in same excel file for analysis
Hi All, When we download "Analyze in Excel" from Power BI Service, it connects to dataset. However, I want to connect to multiple datasets in Excel file to compare. Please advise if this is feasi...
ibarrau
Super User
3 years agoHi. I don't think it's possible for now. You can try it or can suggest the idea at https://ideas.powerbi.com
You can read more about the feature in here: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
- abpgupta3 years ago
Continued Contributor
Just to inform, I was able to connect to different dataset in same Excel file using Get Data option and create another pivot table to compare data.