Dataflow Gen2 Refresh Failure – On-Prem SQL to Fabric Lakehouse

[Alaahady]

Hello everyone,

I’ve set up a Dataflow Gen2 to transfer data from an on-premises SQL Server database to a Microsoft Fabric Lakehouse. While the dataflow creation process completed successfully, the refresh operation failed.

Has anyone encountered a similar issue and found a resolution? Any insights or recommendations would be greatly appreciated.

Best regards,
Al

Error message:

• There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: ActionUserFailure. (Request ID: e301a17b-3046-44b0-a9c1-8c415e2ae333).
• cecdw_def dim_brand_code_WriteToDataDestination: There was a problem refreshing the dataflow: 'Data source credentials are missing or invalid. Please update the connection credentials in settings, and try again.'. Error code: Challenge Error. (Request ID: e301a17b-3046-44b0-a9c1-8c415e2ae333).

[V-yubandi-msft]

Hi @Alaahady ,

I hope everything is good. If you need any additional information or assistance, please let me know.

Thank you,

Yugandhar.

[V-yubandi-msft]

Hi @Alaahady ,

Could you let me know if your issue is resolved, or if you need any additional details.

Thanks.

[Alaahady]

Hi @V-yubandi-msft 

Thank your follow up, 

I'm still struggling with the connection during refresh, Do I have the option to have direct call with Microsoft support?

Alaa

[V-yubandi-msft]

Hi @Alaahady ,

As per the document, I recommend raising a support request. The Microsoft team will then contact you directly.

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

FYI:

For more details, please refer to the attached document.

Power BI and Fabric support overview - Power BI | Microsoft Learn

Thank You.

[V-yubandi-msft]

Hi @Alaahady ,

If your issue is resolved, that’s good to hear. But if you're still facing any difficulties or running into new challenges, feel free to let me know.

Thank You.

[V-yubandi-msft]

Hi @Alaahady ,

Is everything working properly now, or are you still experiencing any issues? Please let us know your feedback may help others who encounter the same situation.

Thank You.

[V-yubandi-msft]

Hi @Alaahady ,

Thanks for posting your query in the Microsoft Fabric Community. If you encounter a Dataflow Gen2 refresh failure when transferring data from an on premises SQL Server to a Microsoft Fabric Lakehouse.

Here are a few ideas to help resolve this issue.

1. Ensure you are using the Standard On Premises Data Gateway rather than the Personal version. The gateway should be installed on a machine with direct access to your SQL Server, and it’s best to use the latest version for compatibility with Fabric.

2. After installing the gateway, sign in with your Fabric account to register it with your credentials. In your Fabric workspace settings, navigate to Manage connections and gateways and create a new connection.

3. Select the on premises option, provide the SQL Server and database information, and use Basic authentication with valid credentials.

4. Also, confirm that the account being used has the necessary read permissions on the source data. If you continue to receive credential errors during refresh, try re authenticating in the Dataflow settings, as credentials may not always persist after publishing. Updating them can often resolve these issues.

Lastly, verify that the gateway can connect to Fabric services by checking that your firewall permits outbound traffic through the required ports and that the machine has access to the necessary domains.

Helpful Reference:
Using an on-premises data gateway in Power Platform dataflows - Power Query | Microsoft Learn
How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

Please troubleshoot using the steps outlined above and also refer to the attached document, which may provide additional helpful insights.

Regards,

Yugandhar.