DmsPbiServiceUserException in Datamart

[Magnum_BI]

Hi,

Getting a "DmsPbiServiceUserException" error when attempting to Save a Import Data Query to a Datamart;

Data being sourced from Azure Data Lake Gen 2 with SAS key authentication.  Connection to works ok, but fails when saving (above).

Any assistance greatly appreciated.

Thanks,

Magnum

[nsp13]

Still seeing this error in May of 2025.

[Magnum_BI]

Yes, after a few months of trying different things and even after getting assistance from MS themselves (via support case etc), I eventually abandoned trying to use this feature.  

[drexelfiend]

I have experienced this issue recently and resolved it by not connecting to an empty data source. I believe an error may have been happening when trying to relate empty data to the other data sources.

[Fcuello]

Hi all,

I'm getting the same error code. I tried to clear it by looking through the message and searching for the presumably blocked database, but no such database exists anywhere within any of my working spaces. I started getting this error after trying to add a date table using dataflow Gen2. I've since deleted this flow to ensure that was not the case, but that is not working either. I have a PPU account.

[JamesBxxx]

Despite this being marked as solved, it is not as of 20/10/2023.

DmsPbiServiceUserException

• ErrorMessageBad Request
• HttpStatusCode400

[bogpop68]

HI,

Same here, when trying to import Excel file from Sharepoint (large one: 200 Mb, 1mil rows...)

[awarriorpoet]

Still receiving this error after bug fix in June.  Any updates?

DmsPbiServiceUserException

• ErrorMessage Bad Request
• HttpStatusCode 400

• Activity ID 35639f0a-8f24-5c9c-7803-644e5570a221
• Request ID 8eddf690-db0a-460a-80da-9197070911a7
• Status code 500
• Error Code DmsPbiServiceUserException

[SFDucati]

This post may help.

Solved: Dataflow Gen2 - Online Power Query Experience Work... - Microsoft Fabric Community

[SFDucati]

Same problem here.  

Activity ID: 19aaff83-88f0-c7e1-8965-b83787af1e47
Request ID: 0f1104f0-3f93-45b2-8b43-0892274e18f6
Status code: 500
Error Code: DmsPbiServiceUserException
Batch ID: bff194f2-e28c-476c-ac5c-7fc8472510b1@71f23ddb-85f0-4036-ab81-d8104e3dcbdf$2023-05-28T18:29:51.3299647Z@5d37df6c-b12d-4b77-abc9-c39b0ca74f5a

[Anonymous]

Getting this more often with datamarts created pre-fabric but if I recreate within fabric they are fine.

[MortenBakke]

I am still experiencing this issue, are there any known fixes?

edit: 02. May 23
I have confirmed the query I am trying to save is working in another datamart but unexplainably returns this error upon saving in the datamart I want it. 

[Magnum_BI · Accepted solution]

Update from Microsoft -

Identified bug.  Fix will be deployed to Production 20/6/23.

[sarmbrecht]

Adding to the list.  I am getting the same error today:  

Activity ID: 669a79f9-fb20-01e2-5a56-3b51bbd8d278
Request ID: 6fa4d008-d41e-4a3a-84c6-d0ae284bbad7
Status code: 500
Error Code: DmsPbiServiceUserException
Batch ID: a63eeb2f-635e-4d57-99cc-afeab88c13af@febfa4e8-d3f6-457b-bb55-f507a7588a46$2023-09-05T20:24:48.7498091Z@2e94219c-1371-477b-87fc-48c1045b29ae

[RG38]

Dear Magnum_BI

I've met the same issue today, do you know if the fix has been deployed please?

[Magnum_BI]

Hi RG,

As of today (23/6), I am no longer receiving this reported error and am able to load data into my Datamart correctly (data from Azure Data Lake Gen 2 with SAS key authentication).

Suggest you contact Microsoft with details in order to sort out.  Good luck.

Magnum

[Magnum_BI]

Hi all,

Several members of the Microsoft PG team are currently working to resolve.  It's a bug, they just dont yet know the cause or solution.

I'll provide update(s) as they become known.

Thanks,

Magnum

[nemozny2]

Same problem. I am trying to load JSON files from a Sharepoint directory. It works in the editing mode, but this final load is failing.

Activity ID: b19a25e3-30c5-24d6-b343-856b29cab275
Request ID: 3a68beb1-2f5b-4e6e-bec0-8c23ec032157
Status code: 500
Error Code: DmsPbiServiceUserException
Batch ID: 205a87a6-e113-41f4-a56e-e459222aa3a1@0962ea93-76cb-49ff-86ff-2bcb28b1feac$2023-04-26T16:35:07.8919297Z@514e1d98-d0c2-470a-8fbc-1059abcd0d6f

[biswarup]

Getting below issues

@v-rongtiep-msft, @Anonymous @Anonymous 

[Anonymous]

[Anonymous]

same issue here 😕