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

TheLoyaltyCo
Frequent Visitor

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.