cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gvwoods
Regular Visitor

Connect to Azure Analysis Service from Power BI Report Server

How can I connect to Azure Analysis Service model from a Power BI Report Server report using the live connection. I've seen posts that state that its not available yet, but in this link https://docs.microsoft.com/en-us/power-bi/report-server/data-sources it says that live connect is a supported data source for Azure Analysis Service. I then scroll down in that link and it does not list an authentication method for Azure Analysis Service.

5 REPLIES 5
Super User IV
Super User IV

Re: Connect to Azure Analysis Service from Power BI Report Server

Should be able to, Get Data | More | Azure | Azure Analysis Services


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

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

gvwoods
Regular Visitor

rRe: Connect to Azure Analysis Service from Power BI Report Server

I don't have an issue in Power BI Desktop (August 2018). I can import and/or connect live and build the report. I then save as Power BI Report Server and if I use import, I have no issues. My issue is afte I have saved the connect live report to Power BI Report server. I then go to the Power BI Report server and it will no longer connect to the data.

TedPattison Responsive Resident
Responsive Resident

Re: rRe: Connect to Azure Analysis Service from Power BI Report Server

It sounds like an issue of the physical server wehre Power BI Report server is running not being able to connect to the cloud. It is possible that the server running Power BI Report Server is on an internal network only accessible to clients inside the LAN? That would explain why a Power BI report can connec to from your desktop computer but not from the server once you publish the report to Power BI Report Server.

 

Can you run tests on the server and see why the connection to Azure Analysis Server is failing?

gvwoods
Regular Visitor

Re: rRe: Connect to Azure Analysis Service from Power BI Report Server

I had the same thought, so I had tested connecting to Azure Analysis Services using SQL Server Management Studio on the Report Server. I was able to connect with no problem.

jeloma Advocate II
Advocate II

Re: Connect to Azure Analysis Service from Power BI Report Server

Post save the pbix in your Power BI Report Server, go to Manage->Data Sources and in Credentials change to "Basic Authentication", with user name and password and Save, and report is render and connect to AAS and perfect for me in August 2018 version.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.