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?
7 Comments
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 _ CaitlynAh, thanks, will do! I actually meant to create a ticket, but I click a wrong link on that support page.
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.
Hi,
I have the same issue, So we don't have any solution to solve it.
Hi,
Adding to subscribe. I also have the same issue, unable to select an authentication method, meaning no changes can be applied:
Any update on this? Does anyone have a workaround? Thanks.
