Forum Discussion
Data Flow - PowerQuery Error - Evaluation resulted in a stack overflow and cannot continue
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.
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.