Forum Discussion
Connect to Azure Analysis Service from Power BI Report Server
Should be able to, Get Data | More | Azure | Azure Analysis Services
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.
- TedPattison7 years agoMicrosoft Employee
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?
- gvwoods7 years agoRegular Visitor
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.