Forum Discussion
Data shows in Power Query, but not in Data view
My source excel file has 30 rows and 10 columns. In the source file, all rows and columns are filled with data. However, when I connect to the file and build out a chart, some data is missing. In the...
I have the same issue. Data can be seen in the Power Query editor but the worksheet is blank except for dates and headers. How do I fix this?
Is your query subject to query folding? I've had situations where my query steps are correct but the folded query is not the same as the steps because it writes bad SQL code.
The solution is to find a fake step that you can add to break query folding.