Forum Discussion
Solved
Create query from sheet or Pivot Table
I have a pivot table, which cannot be turned into a Query. I generated a table off it in another sheet but I cannot turn that table into a Query. Only workaround I found was to create a connection to...
You may use named range and Power Query it. For example, select entire sheet, name it as mySheet and query it as
let Source = Excel.CurrentWorkbook(){[Name="mySheet"]}[Content] in Sourcehowever much better to narrow the range.
In general I'm not sure that's a good idea to transform data from PivotTable with Power Query, perhaps you may receive the same result playing with data model.
Do you not have the raw data that drives the pivot table?
You should be able to find it if you cursor on the pivot; this will open the pivot tabs at the top right of the screen and you can then 'change data' to locate the source.
or i am missing something?