Get data from Pivot Table for financial statement layouts

Hello,

I'm using Power BI Publisher for Excel to connect to a data model in my Power BI Service account.

It seems easier to configure the layout of official financial statements in Excel than on Power BI visuals like tables and matrixes.

Anyway, having the data in a Pivot Table seems promising, but how how about retrieving that data to another cell in Excel?

I know GETPIVOTDATA but it seems a little tricky when the pivot table is redimensioned. I do get a lot of #REF!

What's the best praxis for retrieving data from Pivot tables? CUBE functions? Other functions?

Thanks for helping!