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

KNP's avatar
KNP
Super User
10 months ago

Is this available?

 

If you get the SQL, can you run it directly against the database?

Actually, if you add an index column to the last step of the table (guaranteed to break query folding), do you get a different result?

 

  • SalvaC's avatar
    SalvaC
    Advocate III
    10 months ago

    Yes, Query folding is available.

    There are no further transformations during the import of the tables.

     

    Adding an index column, as suggested, didn't change the outcome.