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.
Ocasio27 Hey Friend,
If your query is just to fill the null values in pivot then you can click on Go to special in Home tab and with the help of that you can do it.
But before doing this you will have to copy the data from pivot and paste as values in the another sheet and then use go to special....