PowerBI Datamart Error Message

[CalebCarter9278]

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":"ExternalServiceUserFailed","pbi.error":{"code":"ExternalServiceUserFailed","parameters":{},"details":[{"code":"ModelingServiceError_Reason","detail":{"type":1,"value":"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.\r\n"}},{"code":"ModelingServiceError_Location","detail":{"type":1,"value":"Connection to AnalysisServices"}},{"code":"ModelingServiceError_ExceptionType","detail":{"type":1,"value":"OperationException"}},{"code":"ModelingServiceError_Message","detail":{"type":1,"value":"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.\r\n"}}],"exceptionCulprit":1}}}
HttpStatusCode400
Status code: 500
Error Code: DmsPbiServiceUserException

Any help would be appreciated.

[CalebCarter9278]

Thank you all for the help. In the end we had to recreate 😞 

[CaptainBI]

I am having the same issue. It started to occur somewhere last week.

Loading data
DmsPbiServiceUserException
ErrorMessage{"error":{"code":"ExternalServiceUserFailed","pbi.error":{"code":"ExternalServiceUserFailed","parameters":{},"details":[{"code":"ModelingServiceError_Reason","detail":{"type":1,"value":"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.\r\n"}},{"code":"ModelingServiceError_Location","detail":{"type":1,"value":"Connection to AnalysisServices"}},{"code":"ModelingServiceError_ExceptionType","detail":{"type":1,"value":"OperationException"}},{"code":"ModelingServiceError_Message","detail":{"type":1,"value":"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.\r\n"}}],"exceptionCulprit":1}}}
HttpStatusCode400
Activity IDd3422a39-f04b-b8ff-d8a6-757edeaeb2e8
Request IDf5999534-5039-4571-9fa3-117d73c15141
Status code500
Error CodeDmsPbiServiceUserException
Batch ID7490ba97-d470-4222-8f42-b7ca5d9af09c@74f3adb4-b507-4ed9-83b8-3ca408ddb729$2023-10-16T12:55:28.1242831Z@679f4b34-7f12-4478-a3fe-632cd70da872

[Anonymous]

See my comment below. Do you see the "Dataverse" connection as well in lineage view or in the Data Source credentials section in settings?

[CaptainBI]

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]

Hi, @CalebCarter9278 @CaptainBI 

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

Best Regards

[CaptainBI]

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.

[Anonymous]

Same issue here. I have had this happen a few times, and I had to recreate the datamart each time. With the last time this issue occured, I went to datamart settings and noticed that I had a Data Source Credential for CommonDataService that failed, and any attempt to edit fails. I didn't recognize the connection, so not sure why this was there. Also, if I view the Datamart in lineage view, I can see that there are two connections to a "Dataverse" that I also didn't setup. I looked through the datamart and there doesn't appear to be any connection to this source. I have dozens of reports and several datamarts, and this is the only one that has this Data source credential or connection in the lineage view.

Are you seeing either of these issues as well?

[Halomar23]

Hi

I'm getting the same issue here. Today I added a new Dataflow connection to the Datamart. I got the error for the first time. Then, I reopened the datamart and, after removing any reference to the dataflow connection, I succeeded saving it.  I repeated the process (adding the same dataflow connection, saving, getting the error, reopening the DM, removing the new connection, saving) a couple times with the same error everytime.

Just to mention: I added different dataflow connections to the DM and they do update correctly! How is it that a specific dataflow gets to crash the entire DM???

[Canadeu]

reynolds82 
Same problem here, we tried everything but to no avail.

please,
Share with us if you can solve or get answers to the problem.

[Canadeu]

@rgomides 

[v-zhangti]

Hi, @CalebCarter9278 

Please refer to the following links in the hopes of helping you.
Datamarts on save are insanely glitchy Status code... - Microsoft Fabric Community

Solved: DmsPbiServiceUserException in Datamart - Microsoft Fabric Community

Control access to datamarts (preview) - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AntSwig]

This reply is useless.