Skip to main content

Power BI

New

Allow connecting to Azure Analysis Services directly from Power BI Service

Vote (46) Share
Mathias Thierbach's profile image

Mathias Thierbach on 29 Jan 2017 21:53:13

Currently, Power BI _Service_ "Get Data" connector for Analysis Services only lists on-prem SSAS instances (provided, Data Gateway is configured), and connections to Azure AS can only be established from PBI Desktop, and via uploading a pbix file with that connection to Power BI Service.

Comments (6)
Mathias Thierbach's profile image Profile Picture

7648e3bf eab6-47dd-ae39-e3edb097e9ea on 05 Jul 2020 23:42:37

RE: Allow connecting to Azure Analysis Services directly from Power BI Service

do we have an eta on this

Mathias Thierbach's profile image Profile Picture

51822787 a9b5-4ec1-8c53-41456adc99d5 on 05 Jul 2020 23:32:58

RE: Allow connecting to Azure Analysis Services directly from Power BI Service

Do we have this functionality in Power BI now????

Mathias Thierbach's profile image Profile Picture

c526668d 5afb-4a48-bffc-ed793f289534 on 05 Jul 2020 23:31:40

RE: Allow connecting to Azure Analysis Services directly from Power BI Service

As a small company, we chose to use Azure Analysis Services instead of an on-premise setup only to discover that we can't connect directly from the online service. Considering the hype around pushing everything to cloud, its really surprising to see a key connectivity feature like this being over-looked. Looking forward to its introduction soon!

Mathias Thierbach's profile image Profile Picture

5af11a61 4e01-4d2a-aa95-c655503f7caa on 05 Jul 2020 23:21:11

RE: Allow connecting to Azure Analysis Services directly from Power BI Service

This is a greatly needed functionality to help in the adoption of real self-service bi with appropriate IT control

Mathias Thierbach's profile image Profile Picture

b8858a36 a8fc-4147-af33-67c41a277c89 on 05 Jul 2020 23:17:12

RE: Allow connecting to Azure Analysis Services directly from Power BI Service

I agree with James. We have invested in Azure Analysis Services (a fairly significant investment for a relatively small company), and our key use case (allowing users to connect to a corporate model on AAS) is not supported from 'Get Data' in Power BI. Considering the amazing progress Power BI has made in the past few years and the push to integrate Power BI to AAS, it is quite surprising that this use case is not supported. Let's vote this up, and get the change.

Mathias Thierbach's profile image Profile Picture

35eaa6f8 6324-4a90-988e-37d2e4d9f645 on 05 Jul 2020 23:00:23

RE: Allow connecting to Azure Analysis Services directly from Power BI Service

I was fairly surprised/disappointed when I realised this functionality wasn't available, especially now that Azure Analysis Services is being pitched directly through the Power BI blog: https://powerbi.microsoft.com/en-us/blog/getting-started-with-azure-analysis-services-webinar-sept-21/

Providing users with the ability to easily query governed corporate data in Azure Analysis Services models directly from the Power BI service would be of great value. The current method of using a pbix file to achieve this is really counter-intuitive: https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-connect-pbi