Forum Discussion
DmsPbiServiceUserException in Datamart
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
Update from Microsoft -
Identified bug. Fix will be deployed to Production 20/6/23.
26 Replies
Hi, did you solve this problem? I meet the same error
i am having the same issue.
Activity ID: 9cf59b3f-5f65-7358-ba43-909734499218
Request ID: a4f6ec3e-ef91-408d-893c-b22d996a769b
Status code: 500
Error Code: DmsPbiServiceUserException
Batch ID: 9ea622b0-109b-40fb-9169-34bc11808dfa@c0fa8289-1137-45f9-8402-150eb1cc9f48$2023-07-04T22:32:46.7945192Z@59a8834e-ed57-4180-950d-8ac626746adecan you please shed some lights on this?
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 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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Getting below issues
@v-rongtiep-msft, Anonymous Anonymous
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-1059abcd0d6fHi 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
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.
