Published file is very slow

Hi  Syndicate_Admin ,

In the powerbi service, there are many factors that can affect the query response time. Network latency, different browsers, the dax function itself. Even different connection modes can have an impact.

Refer to.

https://blog.crossjoin.co.uk/2019/12/02/testing-performance-of-power-bi-reports-in-the-browser-part-1/

You can check the following:

1. Clear your browser cache, cached data in your browser can sometimes cause performance issues. Clear the cache and try to access the published file again.

How to Manage and Clear Your Cache and Cookies | Edge Learning Center (microsoft.com)

2. Check the file size and content, make sure the file size is optimized, remove unnecessary data or reduce the file size as much as possible, complex formulas, large data sets can also cause slowdowns, you can optimize the complexity of Dax.

Optimization guide for Power BI - Power BI | Microsoft Learn

3. You can put Excel into the database, use Direct Query mode to connect, so that when running directly query the database, and Import connection mode in the latest data when you get the latest data, you need to load the latest data from the local to replace the previous data.

DirectQuery in Power BI - Power BI | Microsoft Learn

4. Check the network connection, network delays can also lead to slow running.

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.