Hi,
Is there a quick way (ideally in fle explorer) which would show me this excel has a pivot table (added to data model) or this excel contains Pivot table with Measures? Or tbh would be handy if was a quick identifier to show just this excel contains a pivot table. The same identifier would be handy if shown these files are all linked to power query... I digress.
If not from file type property in explorer (which would be ideal so dont have to open multiple saved excels)....is there a way to export all measures from pivot table into a work sheet?
Many Thanks
Gareth
Is there a quick way (ideally in fle explorer) which would show me this excel has a pivot table (added to data model) or this excel contains Pivot table with Measures? Or tbh would be handy if was a quick identifier to show just this excel contains a pivot table. The same identifier would be handy if shown these files are all linked to power query... I digress.
If not from file type property in explorer (which would be ideal so dont have to open multiple saved excels)....is there a way to export all measures from pivot table into a work sheet?
Many Thanks
Gareth