Forum Discussion

LaurentZ's avatar
LaurentZ
Helper I
3 years ago

Import pivot table data source in power query. Is it possible ?

Hi,

 

I need to import data from an excel file (not done by me) in which there is a pivot table with its data source (saved in the file).

 

I could format the pivot table to suit my needs or regenerate the data by double-clicking somewhere in the pivot table, but this involves opening the file and storing the result somewhere.

 

So I wonder if it is possible to import the "hidden" data source of the pivot directly into Power Query?

 

Thank you.

No RepliesBe the first to reply