Data source credentials for Datamart error

[nemozny2]

Changes to my datamart often fail on 400 error.  I must say that error reporting in Datamart is rather poor, since all errors are very general. The desktop at least tells me what specific table failed.

Anyway, the only thing I did was to "Enable load" on one table, that I originally disabled. Now the refresh fails

Wrapping things up

OperationCanceled

• ErrorMessageThe current operation was canceled because one or more operations failed.
• HttpStatusCode400

• Activity IDd518fa90-a34d-7114-cee2-72d4cf4c73a4

• Request IDa290831c-a96d-44f9-a9d1-cf51c187a74b

• Status code500

• Error CodeOperationCanceled

• Batch ID205a87a6-e113-41f4-a56e-e459222aa3a1@0962ea93-76cb-49ff-86ff-2bcb28b1feac$2023-05-19T14:29:29.4086572Z@950a1752-deb6-4d04-b148-8447cb7e4cc8

and I can see this in my Datamart "Data source settings":

The dropdown "Authentication method" is empty for both "Web" entry and this blank entry (datamart).

I have chosen "Organizational" and clicked "Sign in" and that produced the above error.
Could the datamart changes error and this error be related?

[Anonymous]

Hi @nemozny2 ,

We see that you mentioned：

“The dropdown "Authentication method" is empty for both "Web" entry and this blank entry (datamart).”

:we were not able to reproduce the problem.Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn

[nemozny2]

Ah, thanks, will do! I actually meant to create a ticket, but I click a wrong link on that support page.

[nemozny2]

I have had a session with your support and those Datamart credential settings are an unfixed bug, as of now.

However my "Enable load" problems were unrelated to those credentials.

In the end if I made only one change in my datamart at a time, it managed to save and refresh.

I did not get a confirmation, but in my case it looked as my 2 tables were simply too big (6000 and 11000 rows) and "enable load" on both of them at the same time ended up in an error.

In the end I have to admit I have dropped Datamart in favor of Dataflow. I am new to both, but Dataflow works much better for my case.

[quizhyo]

Hi, 

I have the same issue, So we don't have any solution to solve it.

[AdamDel]

Hi,

Adding to subscribe. I also have the same issue, unable to select an authentication method, meaning no changes can be applied:

[quizhyo]

@AdamDel  it's not affect of datamart

It happens when we use the SQL query (for me). Schedule refresh is still oke

[jstrugnell]

Any update on this? Does anyone have a workaround? Thanks.