Forum Discussion

Iron Contributor

Jun 16, 2020

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...

BI & Data Analysis

Formulas and Functions

power bi

SergeiBaklan
Jun 16, 2020
Ocasio27

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 Source

however 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.

SergeiBaklan

Diamond Contributor

Jun 16, 2020

Ocasio27

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
    Source

however 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
Iron Contributor
Jun 17, 2020
SergeiBaklan

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.
- SergeiBaklan
  Diamond Contributor
  Jun 17, 2020
  Ocasio27
  
  It means you didn't name the range. You could do it directly in name box
  
  or in Name Manager