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

If query folding is happening, can you see anything strange in the SQL query?

Do all the columns have data types assigned? (no ABC 123 columns)

If query folding is not happening, can you make changes so that it does?

 

I'm just thinking of the troubleshooting steps I would start with.

 

  • SalvaC's avatar
    SalvaC
    Advocate III
    10 months ago

    Yes, all columns have the datatypes as defined in the database.

    The source is an on-prem SQL Server database.

     

    Interestingly, disabling the loading of the table listed in the error message causes the following table (in alphabetical order) to appear in the error message.

    For this reason, I don't think it is a data issue, but rather a more fundamental one.