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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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

26 REPLIES 26
nsp13
New Member

Still seeing this error in May of 2025.

 

nsp13_0-1748037279639.png

 

 

Yes, after a few months of trying different things and even after getting assistance from MS themselves (via support case etc), I eventually abandoned trying to use this feature.  

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 

Anonymous
Not applicable

usercentrics_0-1679387728516.png

 

Anonymous
Not applicable

same issue here 😕

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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