Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

 

Update from Microsoft -

 

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

 

View solution in original post

24 REPLIES 24
drexelfiend
New Member

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

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.

 

Fcuello_0-1704813942579.png

 

JamesBxxx
Regular Visitor

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

DmsPbiServiceUserException

  • ErrorMessageBad Request
  • HttpStatusCode400
bogpop68
Frequent Visitor

HI,

 

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

bogpop68_0-1689750247429.png

 

awarriorpoet
Helper I
Helper I

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
Helper I
Helper I

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
Not applicable

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

MortenBakke
Frequent Visitor

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.

 

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

Dear Magnum_BI

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

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
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, @Anonymous @Anonymous 

usercentrics
Regular Visitor

usercentrics_0-1679387728516.png

 

usercentrics
Regular Visitor

same issue here 😕

Anonymous
Not applicable

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!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors