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

[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

[TheLoyaltyCo]

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]

Update from Microsoft -

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

[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, @v-rongtiep-msft @v-rongtiep-msft 

[usercentrics]

[usercentrics]

same issue here 😕

[v-rongtiep-msft · Accepted solution]

Hi @Magnum_BI ,

Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

Best Regards
Community Support Team _ Polly

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

[nemozny2]

Although I don't see a solution update here, I can confirm the problem was fixed.

I got an error that the service was upgraded from v3 to v4 and my problem is gone.

Thanks MS!

[Magnum_BI]

Thankyou.

[VTG]

I have the same issue. How do we fix it?? I go back to the query and check there is nothing wrong with it as I use the query in another power bi report.

[halliewu]

Hi, did you solve this problem? I meet the same error