Connect multiple Datasets in same excel file for analysis

[abpgupta]

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.  

[abpgupta]

In that case, I need to connect two excel files to different datasets and use them again in Power BI Desktop to compare 🙂

[ibarrau]

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

[abpgupta]

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.

[ibarrau]

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

[abpgupta]

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.