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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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

23 REPLIES 23
Fcuello
Regular 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
Frequent Visitor

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

Thankyou.

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors