Does anyone have a way to extract power query results when one of the steps crashed (and lets say there is no way to fix it)? There are a lot of working pivot tables based on power queries so there has to be data somewhere. There is also a Data Model in power pivot and I know that I can copy all the results from power pivot and paste into some worksheet but it crashes power pivot when I want to copy so many results

CodePudding user response：

I depends whether or not it as ever worked.

To my knowledge, PowerQuery only has a preview of the data. So, it does not retain a copy of the source. Even though I don't know if you can access these previews in a meaningful way.

However, if it as loaded in PowerBI at some point (when you hit "Apply" in PowerQuery). You can extract it in its current state using DAX Studio. You'll get more or less exactly what you can see in PowerBI except there is an option to extract to CSV.

CodePudding user response：

You have to go into Existing Connections and check Table that corresponds to power query and then you can load it to a sheet even if the power query is down