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

Hi SalvaC,

Thank you for the update.

From your message, it appears you have implemented a practical workaround by moving the data refresh logic from Dataflow Gen1 to the Power BI report’s semantic model. This is an acceptable approach when Dataflow Gen1 refresh failures persist, because the Power BI service employs a different refresh engine for datasets that often avoids the transient gateway handshake issues affecting Gen1 dataflows.

If you wish to continue investigating the original issue at a later time, we recommend migrating your Gen1 dataflow to Dataflow Gen2, as the newer version offers improved reliability, performance and diagnostic capabilities compared with Gen1. 

Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.