Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

nemozny2

Data source credentials for Datamart error

Submitted by on ‎05-19-2023 07:58 AM

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":

nemozny2_0-1684508106184.png

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?

Status: Investigating
See more ideas labeled with:
7 Comments (7 New)
Comments
Anonymous
Not applicable
‎05-22-2023 02:24 AM

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
Frequent Visitor
‎05-22-2023 03:58 AM

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

nemozny2
Frequent Visitor
‎06-05-2023 08:27 AM

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
Advocate I
Advocate I
‎06-06-2023 07:47 PM

Hi, 

 

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

 

quizhyo_0-1686105997725.png

 

AdamDel
Frequent Visitor
‎06-16-2023 03:50 AM

Hi,

 

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

 

AdamDel_1-1686912513801.png

 

quizhyo
Advocate I
Advocate I
‎06-21-2023 02:22 AM

@AdamDel  it's not affect of datamart

 

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

jstrugnell
New Member
‎11-20-2023 08:14 AM

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

Idea Statuses