How to connect Azure analysis service from excel and powerBI online app using office 365

Question

PowerQuery is not available in office 365 excel online version and unable to connect with Azure analysis service.
while I can connect to Azure analysis service using Get Data in Excel desktop version but same feature is not available in online office365.

1) My query is how can I do it?

Same is true for PowerBI, I can connect Azure analysis service from PowerBI Desktop application but when I use online powerBI app like https://app.powerbi.com/ url, I couldn't see connectivity option for Azure analysis service

2) My second query is how can I connect Azure Analysis service from app.powerbi.com ?

Any help will be appreciated.
Thanks in advance.

Answer 1

Hello @Krishna Dubey ,

Welcome to Microsoft Q&A platform.

Unfortunately, you cannot connect Azure Analysis services from Excel online and Power BI online (app.powerbi.com)

I would suggest you to vote up an idea submitted by another Azure customer.

https://feedback.azure.com/forums/556165-azure-analysis-services/suggestions/17928280-azure-as-data-connections-in-excel-online

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

Get & Transform (Power Query) is not supported on Excel Online.

Reference: Where is Get & Transform (Power Query)

I would suggest you to vote up an idea submitted by another customer.

https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/37405945-get-and-transform-excel-online

Azure Analysis services is not supported in Power BI Services.

Reference: Data Sources in Power BI

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.