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
Solved! Go to 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.
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
Getting this more often with datamarts created pre-fabric but if I recreate within fabric they are fine.
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.
Update from Microsoft -
Identified bug. Fix will be deployed to Production 20/6/23.
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
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
same issue here 😕
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.
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!
Thankyou.
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.
Hi, did you solve this problem? I meet the same error