Skip to main content

Power BI

Needs Votes

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

wayne 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

Hari 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

Hisham Shahbaz 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

Mihaly Kavasi 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

Power BI User 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

James Pretorius 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