How to obtain a datatable of a Power Pivot?

Hello everyone,

I’m trying to get a data table from a Power Pivot.

I want to recover the headers to later carry out a filter, but this does not work.

Does anyone know how to get the data of a Powe Pivot?

I have tried to get the data through a Read Range, but this only returns the range of the table …

I would appreciate any help, thank


Finally I found the solution, attached example to obtain the data of a Pivot Table.

You will have to go through the table with the index.
Extract Pivot (165.9 KB)