Forum Discussion

SalvaC's avatar
SalvaC
Advocate III
10 months ago
Solved

Dataflow Gen 1 keeps failing

Hi all   I have a Dataflow Gen 1 connected to an on-prem SQL Server DB through an On-Prem Gateway. All looks well.   When I enter edit mode, I can see the data and refresh the preview. The colu...
Need Help
  • SalvaC's avatar
    SalvaC
    10 months ago

    Hi all,

     

    We have updated the Gateway, but it has had no effect.

    We still have the same error (with no detailed error message).

     

    After checking the lineage of the DataFlow, we noticed that its data is used only by one report.

    Therefore, we moved the Load to the Power BI Report (Semantic Model), and we will remove the DataFlow in due course.

     

    I would have preferred to solve this issue and post the solution, but this is the most pragmatic solution for us.

     

    Kind regards

    Salvatore

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
10 months ago

Thankyou, KNP, and Automagical for your responses.

Hi SalvaC,

We appreciate your enquiry submitted via the Microsoft Fabric Community Forum.

Based on my understanding, the failure may be caused by an intermittent connectivity or handshake issue between the Power BI service and the on-premises data gateway during dataflow execution. Possible reasons include an outdated gateway version, a transient service incident, gateway resource exhaustion, a timeout while establishing the connection, or a backend issue affecting Dataflow Gen1 refreshes.
Please follow the steps below, which may help resolve the issue:

  1. Open the on-premises data gateway application and confirm its version and status. Ensure you are running the latest gateway build and that it is online.
  2. Re enter the data source credentials by navigating to Manage Gateways → select the SQL Server source → Edit credentials → Test connection.
  3. Create a new dataflow using a single small table through the same gateway. If this also fails, the issue is likely related to the gateway or the service.

Additionally, please refer to the link provided below:
Troubleshoot the on-premises data gateway | Microsoft Learn

We hope the information above helps to resolve the issue. If you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

SalvaC's avatar
SalvaC
Advocate III
10 months ago

Thank you for your advice.

 

I already did the first two things, without success.

 

I need to talk with the system admins for the update, as this is a client's system and it's a qualified environment.

This will take some time.

I will come back here as soon as I have an update.

 

Kind regards
Salvatore