Forum Discussion
Data Flow - PowerQuery Error - Evaluation resulted in a stack overflow and cannot continue
I am trying to create a DataFlow for a 2.6GB fact table and I am getting this error: This is on a P3 node, so you would think that the capacity is not an issue. Any ideas? Can a diagno...
Strangely, putting in an explicit "SELECT *" SQL source query worked instead of choosing the view object from the PowerQuery interface. Don't know why, but it fixed my issue.
Side question. We are trying to reduce load on the DW by creating base Data Flows that other workspaces can base their own Data Flows off of. This should limit every single dataset from query redundant data from the DW. It also puts the files in ADLS which opens the data up for other uses-cases like ML or Databricks.
lbendlin
Super User
Super UserYou will want to do performance comparisons. I don't think dataflows will gain you anything in that particular scenario.