Forum Discussion
LaurentZ
3 years agoHelper I
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