cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Magnum_BI
Frequent Visitor

DmsPbiServiceUserException in Datamart

 

Hi,

 

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

 

Magnum_BI_0-1678405651101.png

 

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

 

 

 

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

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.

View solution in original post

14 REPLIES 14
SFDucati
Frequent Visitor

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
Frequent Visitor

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

MortenBakke
New Member

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.

 

Magnum_BI
Frequent Visitor

 

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
Frequent Visitor

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
Frequent Visitor

Getting below issues

biswarup_0-1680334705855.png

@v-rongtiep-msft, @v-rongtiep-msft @v-rongtiep-msft 

usercentrics
Regular Visitor

usercentrics_0-1679387728516.png

 

usercentrics
Regular Visitor

same issue here 😕

v-rongtiep-msft
Community Support
Community Support

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.

 

VTG
New Member

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
New Member

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

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.