Forum Discussion
Connect 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 feasible.
5 Replies
Hi. 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
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.
In that case, I need to connect two excel files to different datasets and use them again in Power BI Desktop to compare 🙂
If you want to create a new dataset connected to two excel files, you can do it for sure. Just open Power Bi Desktop and connect. If you want to connect a Power Bi Desktop to a dataset and add an excel file you can also do it, look for "composite models". That's the name for that last example.
I hope that make sense
Yes, I wanted to avoid all those additional steps and objects creations by connecting in same excel file to compare data and present formatted outputs.
Also, that way I don't need to create Paginated report for formatted outputs and users will just open Excel file and refresh data according to what they want.
