Urgent: Analyze in Excel Feature-Unable to open Excel file

[IgorGershenson]

Hi, I used Analyze in Excel to bring a large dataset into a pivot to share with some of my colleagues. Now the file refuses to open. I keep seeing this message and it stays at 0% forever. Any clue how I can get back into the excel file? Would not want to recreate this pivot since it took a while to create the pivot. 😞

[v-chenwuz-msft]

Hi @IgorGershenson ,

Did you try this with a small dataset or open it in another computer? for this can test if it is the issue with excel.

Or you can try to connect to power bi dateset from excel directly. 

https://datacornering.com/how-to-connect-to-power-bi-dataset-with-excel/ 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.