Underlying data of a pivot table

[Anonymous]

Hello everyone,

I hope there is a workaround on this as I am not well versed on how this works. So, there is an excel file that is being uploaded to a sharepoint automatically that has a pivot table in it. This pivot table seems to be connected to a private server which I can't connect. I have to double click the total of the pivot table to be able to see the underlying data which I use to create a report in PowerBI.

Is there a way in to get the underlying data without me getting into the excel file?

Thanks!

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Generally speaking, we import data into Desktop without opening excel, try to get access to the private server, or put the file in any folder you have access to and try again.

Best Regards

Lucien