Timeout Issues in Power BI - Need Help Resolving Visual Loading Error

Hi Masakinka ,

Thanks for the reply from SaiTejaTalasila , please allow me to provide another insight: 

DirectQuery sends all requests to the source database, so the time it takes for a visual to refresh depends on how long it takes the underlying source to return results. Five seconds or less is the recommended response time to receive the data requested by a visual. Refresh times longer than 30 seconds create an unacceptably poor experience for people using the report. In the Power BI service, queries that take longer than four minutes time out and users receive an error. This limit is designed to prevent issues caused by long execution times. You should only use DirectQuery for sources that can provide interactive query performance.

You can start diagnosing performance issues in Power BI Desktop, not in the Power BI service. Performance issues are often based on the performance of the underlying source. It's easier to identify and diagnose issues in a more isolated Power BI Desktop environment.

More detailed information is available in the documentation:

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn

DirectQuery in Power BI - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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