Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with Azure Analysis Services connection in Power BI service

I'm having trouble getting a dataset deployed to the Power BI service work with Azure Analysis Services. My scenario is:

  • I have create an Azure Analysis services server in my MSDN Azure Tenant
  • I have granted access to this tenant with my work account
  • Using my work account, I have deployed a Tabular model to Azure Analysis Services
  • I have connected Power BI desktop to Azure Analysis Services and successfully connected to the database
  • From here I can build an example report in Power BI desktop
  • I then publish the Power BI desktop file to our Power BI tenant (I have tried both publishing to a normal workspace and an embedded capacity)
  • When I open the report or the dataset in the Power BI tenant I get the error "
     
    Cannot Load the 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."
  • To debug this I tried editing the credentials. It appears to connect successfully but the error persists

Is there something I have done incorrectly? What else could I try to debug this?

  • Anonymous's avatar
    Anonymous
    6 years ago

    Nevermind. It was a security issue. I was able to resolve it by logging in to power bi with a user that has access to the tabular model. I wasn't aware that you couldn't share credentials

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Nevermind. It was a security issue. I was able to resolve it by logging in to power bi with a user that has access to the tabular model. I wasn't aware that you couldn't share credentials