Forum Discussion
Anonymous
6 years agoNot applicable
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?
- Anonymous6 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
- AnonymousNot 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