Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

PowerBI Datamart Error Message

I am getting an error message when I am trying to save changes to a datamart on power query. Below is the error message:   DmsPbiServiceUserException ErrorMessage{"error":{"code":"ExternalServiceU...
Need Help
CaptainBI's avatar
CaptainBI
Frequent Visitor
2 years ago

Hi, neither of them. I do see one red coloured "empty" Data Source Credential among my 4 credentials that I am not able to edit. The database field is blanked out, the authentication method dropdown list is empty and privacy level is selectable. If I click sign in it results in Failed to update data source credentials.

 

 

 

What I also notice in my Datamart: the tabs "Data" and "Query" work just fine.

When I click "Model" I get:

 

Error Loading Data Model

The database was not found in Power BI. Please check if it was deleted, or if you do not have permission to access it. Redeploying the database may also succeed, if the database can be recreated.

 

 

v-zhangti's avatar
v-zhangti
Community Support
2 years ago

Hi, Anonymous CaptainBI 

 

What specific data source is being used? Please provide more information.

 

Best Regards

 

 

  • CaptainBI's avatar
    CaptainBI
    Frequent Visitor
    2 years ago

    MS Dynamics CRM

     

    I made a ticket with PBI Support and the answer I got is that I have to recreate the whole DM. Ouch.