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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FilipVDR
Helper I
Helper I

Problems running DataFlow in Fabric

Problems running Dataflows within Fabric.

I'm trying to follow this step by step.

https://learn.microsoft.com/en-us/power-bi/fundamentals/fabric-get-started

 

I was able to create this Dataflow and a lakehouse.

I'm having issues when refreshing the Dataflow from MyWorkspace.

FilipVDR_0-1685430573523.png

 

null Error: Data source credentials are missing or invalid. Please update the connection credentials in settings, and try again..

When in my Dataflow, and i connect with my organisational account it works, but when i go back a few moments later it is gone again. Any idea or tips? 

 

Also: When creating a Data Pipeline i'm getting an error: Failed to load dataflows. Request failed with status code 401.

 

Thanks!

2 ACCEPTED SOLUTIONS
SidJay
Employee
Employee

We believe this is an issue specific to My Workspace which occurs in either of the following cases:

1) A query that references another query which has Load enabled

2) A query that outputs to a destination and also has Load enabled

 

We are investigating the issue and will release a fix as quickly as feasible.

 

In the interim we believe it should be possible to temporarily work around these issues by using a workspace other than My Workspace.

 

Thanks.

View solution in original post

SidJay
Employee
Employee

The issues specific to "My Workspace" are now resolved. For on-premises scenarios, you need the latest version of the Gateway (3000.174.13, published on June 2nd).

 

Thanks.

View solution in original post

15 REPLIES 15
SidJay
Employee
Employee

The issues specific to "My Workspace" are now resolved. For on-premises scenarios, you need the latest version of the Gateway (3000.174.13, published on June 2nd).

 

Thanks.

Hi SidJay, 

Thank you for your help.
I've updated the gateway as requested.

I'll keep you posted should the issue return.

KR.

SidJay
Employee
Employee

We believe this is an issue specific to My Workspace which occurs in either of the following cases:

1) A query that references another query which has Load enabled

2) A query that outputs to a destination and also has Load enabled

 

We are investigating the issue and will release a fix as quickly as feasible.

 

In the interim we believe it should be possible to temporarily work around these issues by using a workspace other than My Workspace.

 

Thanks.

I have the same exact issue, but in a workspace that is not My Workspace, so the workaround suggested does not work. Same exact scenario with the organizational logins and the fails are writing due to the token issue described. The pull for our Azure DB works just fine. Are you aware of that this issue is not just in My Workspace?

Also get the same error when pulling data from the Lakehouse with the Gen2 dataflow. I just used copy to successfully load data into the lakehouse I just created and then attempted to use the Lakehouse as the source and got the login error.

Hello @Dave_De,

 

would it be possible to share a screenshot of the failure you are hitting with Request/Session IDs so we can drill down into the issue?

 

Thanks,

Frank.

I beleive I may have found the issue. If you change the name of the lakehouse even before you have set it as a desitination in the dataflow, then it will fail, but changing it back to the original name helps it go through. Below are the screenshots:

Dave_De_1-1688418146695.pngDave_De_2-1688418157013.png

 

Same problem, once I used a different workspace it worked fine 🙂

 

Thanks! When running my testflow in an other workspace it works. 

DIMBACKA
Frequent Visitor

Something additionally which I notice:
It seems like the owner of the resources created by me are (correctly) assigned to my personal account.
But the auto created ones are having an owner called "My Workspace". 
Could this cause the authentication issues with the (non-saved) credentials?

DIMBACKA_0-1685447455493.png

 

frlunett
Employee
Employee

Hello @FilipVDR,

 

thanks for reporting the issue. Would you be able to share additional information for both cases mentioned above:

 

- are you using a gateway to load data to the lakehouse destination?

- would you be able to share the RequestID/SessionId from the refresh operations in both cases? this will help with troubleshooting. You can find this information in the refresh history page:

frlunett_0-1685440206033.png

 

Thanks,

Frank.

Hi all, 
Same issue here. It seems like the credentials used to setup the data connection are not being saved.

DIMBACKA_0-1685445182013.png

 

Yes true, when I go back to the dataflow and look for the connection to write to the Datalake, I have to sign in every time I go back. 

hi Frank,

 

- no, even if I make a dataflow and I just enter raw data (one line, one column), that fails

FilipVDR_0-1685443907256.png

 

FilipVDR
Helper I
Helper I

Seems i got a similar error: even when I create a new dataflow and enter data with one column and one row, and I want to write it to the lakehouse i get an error: 

 

FilipVDR_0-1685432725653.png

 

It seems that the dataflow can't save my connection using my Organizational Account

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

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.

Top Solution Authors