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.
I get this error. The problem is, there is no table in that sheet
Expression.Error: We couldn't find an Excel table named 'mySheeet'.
Details:
mySheet
It needs to be in a query in order to modify it and export it to Tableau.
It means you didn't name the range. You could do it directly in name box
or in Name Manager