topic Re: DmsPbiServiceUserException in Datamart in Service

DmsPbiServiceUserException in Datamart

Magnum_BI — Thu, 09 Mar 2023 23:51:34 GMT

Hi,

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

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

Re: DmsPbiServiceUserException in Datamart

halliewu — Wed, 15 Mar 2023 13:05:36 GMT

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

Re: DmsPbiServiceUserException in Datamart

VTG — Thu, 16 Mar 2023 01:07:24 GMT

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.

Re: DmsPbiServiceUserException in Datamart

Anonymous — Tue, 21 Mar 2023 02:15:08 GMT

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.

Re: DmsPbiServiceUserException in Datamart

Magnum_BI — Tue, 21 Mar 2023 06:36:26 GMT

Thankyou.

Re: DmsPbiServiceUserException in Datamart

Anonymous — Tue, 21 Mar 2023 08:32:49 GMT

same issue here 😕

Re: DmsPbiServiceUserException in Datamart

Anonymous — Tue, 21 Mar 2023 08:35:36 GMT

Re: DmsPbiServiceUserException in Datamart

biswarup — Sat, 01 Apr 2023 07:39:20 GMT

Getting below issues

@v-rongtiep-msft, Anonymous Anonymous

Re: DmsPbiServiceUserException in Datamart

nemozny2 — Wed, 26 Apr 2023 16:38:27 GMT

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

Re: DmsPbiServiceUserException in Datamart

Magnum_BI — Wed, 26 Apr 2023 23:44:49 GMT

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

Re: DmsPbiServiceUserException in Datamart

MortenBakke — Tue, 02 May 2023 09:59:18 GMT

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.

Re: DmsPbiServiceUserException in Datamart

nemozny2 — Fri, 28 Apr 2023 17:44:49 GMT

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!

Re: DmsPbiServiceUserException in Datamart

Magnum_BI — Thu, 25 May 2023 03:35:34 GMT

Update from Microsoft -

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

Re: DmsPbiServiceUserException in Datamart

Anonymous — Thu, 25 May 2023 13:05:15 GMT

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

Re: DmsPbiServiceUserException in Datamart

SFDucati — Sun, 28 May 2023 18:33:43 GMT

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

Re: DmsPbiServiceUserException in Datamart

RG38 — Thu, 22 Jun 2023 17:06:42 GMT

Dear Magnum_BI

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

Re: DmsPbiServiceUserException in Datamart

Magnum_BI — Thu, 22 Jun 2023 23:28:39 GMT

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

Re: DmsPbiServiceUserException in Datamart

kynejin — Tue, 04 Jul 2023 22:35:45 GMT

i am having the same issue.

Activity ID: 9cf59b3f-5f65-7358-ba43-909734499218
Request ID: a4f6ec3e-ef91-408d-893c-b22d996a769b
Status code: 500
Error Code: DmsPbiServiceUserException
Batch ID: 9ea622b0-109b-40fb-9169-34bc11808dfa@c0fa8289-1137-45f9-8402-150eb1cc9f48$2023-07-04T22:32:46.7945192Z@59a8834e-ed57-4180-950d-8ac626746ade

can you please shed some lights on this?

Re: DmsPbiServiceUserException in Datamart

awarriorpoet — Thu, 13 Jul 2023 00:53:55 GMT

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

Re: DmsPbiServiceUserException in Datamart

SFDucati — Thu, 13 Jul 2023 16:14:25 GMT

This post may help.

Solved: Dataflow Gen2 - Online Power Query Experience Work... - Microsoft Fabric Community