Forum Discussion
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":"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.
12 Replies
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?
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.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???
Hi, Anonymous
Please refer to the following links in the hopes of helping you.
Datamarts on save are insanely glitchy Status code... - Microsoft Fabric CommunitySolved: 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.
This reply is useless.
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-632cd70da872Hi, 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.
