Forum Discussion

CoulterJames2's avatar
CoulterJames2
Icon for Advocate II rankAdvocate II
6 years ago

Power BI Report Server - Live Connection to Azure Analysis Services

I have an Power BI Report Server and the associated edition of Power BI Desktop (September 2019). I am trying to create a Power BI report that gets data from an Azure Analysis Services tabular model ...
Azure Analysis services tabular model
Live Connection
Report Server
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago
CoulterJames2 wrote:

 

 I am working on a server that might have some firewall restrictions.

 

So I suggest you start by checking these firewall restrictions. One quick check could be to try running a client tool like Power BI Desktop or SSMS. Or if you don't want to install either of those you could also try running a query against AAS using Powershell. This will let you check if the issue is related to PBIRS or if it is a general connection issue.

  • CoulterJames2's avatar
    CoulterJames2
    Icon for Advocate II rankAdvocate II
    6 years ago

    As I mentioned originally, SSMS can connect to the tabular model fine. Power BI Desktop (RS) does not. I can import data from the model, but cannot connect live.

    • d_gosbell's avatar
      d_gosbell
      Icon for Super User rankSuper User
      6 years ago

      Sorry I misread your post and through you were getting the error after uploading to PBIRS

    • jesse_james's avatar
      jesse_james
      Icon for Helper I rankHelper I
      6 years ago

      Hi, any solutions for this one?

      I am having the same error...