Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unable to connect to SSAS Tabular from Service

Power BI desktop connect well to the Azure Analysis service but not from Power BI Service. Below are the error details-

 

Couldn't load the schema for the database model
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 07c4ed63-e88b-4565-b9bc-71d9ea5589f9
Request ID: 08b6f607-6617-b167-6d84-9d78b3c7144a
Correlation ID: 0486b5d7-5ae5-273e-1fbb-4f8bae997be4
Time: Tue Oct 23 2018 17:35:08 GMT+1100 (Australian Eastern Daylight Time)
Version: 13.0.7055.182
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net

 

Can anyone of you please let me know the resolution.

Need Help
Show and Tell

17 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Is you SSAS hosted in the Azure cloud?  When you click on the elipse next to the dataset in the Power BI Service, do you see this:

     

     

     

    If your SSAS is inside your network, have you set up an On-Premise data gateway and created a Data Source in Manage Gateways for the Analysis Services?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks Ross for responding quickly. The SSAS is hosted in cloud but when I follow your process and click on the elipse I see a slightly different one - 

       

      I've also tried to click explore the option of "Analyze in Excel" and when I clicked on the option, a excel workbook was downloaded. When I opened the workbook, it prompted for the credentials to connect to Azure and when I'm done I was able to connect to the Tabular model without any issues.

       

      Kindly let me know if you need further information.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        When you connected to your SSAS, did you do so as a live connection or as an Import?