Azure usage with Excel instead of the PowerBI service

[Cathryn]

Hi Everyone!

I have users that like the Azure Enterprise dashboard that you can create with the template but they don't want to have to download the data everytime to create their own pivot tables.  I know they can create pivot tables within the PBI service but they love excel and just want to be able to refresh a spreadsheet that they keep.  

In Excel, you can create connections to a database, can you create a connection to the Azure ea.azure.com directly in excel?

I'm not sure if I'm making sense...

Thanks

Cathryn

[v-yuezhe-msft]

@Cathryn ,

According to my knowledge, we are not able to create a connection to Azure Enterprise directly in Excel.

In addition, after you connect to Azure Enterprise in Power BI Service, you can directly connect to the Azure Enterprise dataset in Excel after installing Power BI publisher for Excel.

Regards,
Lydia Zhang