Exporting from power bi to excel taking too long...

[Anonymous]

I try to export from app.powerbi to excel and it never completes… I waited for at least 20’ and is still loading, how can I troubleshoot this?

Perhaps, can I put a filter to whatever I am downloading?

[arvindsingh802 · Accepted solution]

There are multiple reason behind this

1. Data volume is hudge - Yes applying filter will help

2. Network speed (Consider VPN Bottleneck) - try to connect different VPN is available

Also you can try analyze in excel feature with large data volume

If this post helps, then please consider Accept it as the solution and give it a thumbs up

[SheGutay_PBI]

I am experiencing this problem since yesterday. Will try the possible solutions provided on the replies.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Usually, it should not spend more than one minute to export data with large dataset. For you scenario, please check if your report contains too much data and complex report definition. Also check if the network is under heavy load. You can try to clear the cache of web browser. And re-publish the report to service for a test.

Here is the document about optimization, you can view this content:

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

https://maqsoftware.com/expertise/powerbi/dax-best-practices

Best Regards,

Liu Yang

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

[arvindsingh802 · Accepted solution]

There are multiple reason behind this

1. Data volume is hudge - Yes applying filter will help

2. Network speed (Consider VPN Bottleneck) - try to connect different VPN is available

Also you can try analyze in excel feature with large data volume

If this post helps, then please consider Accept it as the solution and give it a thumbs up