Issue with refreshing the Power BI

[Anonymous]

Hi,

I have been constantly getting errors refreshing the Power BI report which is connected to a SQL server in a semantic model. The size of the report is approx 600mb. The report tries refreshing for a long time and then gives the following error:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: de_transaction.
Cluster URI: WABI-WEST-US-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 7902fda1-456c-4959-a151-6ea69ee3645f
Request ID: 85a59f24-4bd6-a1f9-1673-a698918f4ea9
Time: 2024-01-31 21:40:45Z

I have tried a lot of solutions provided in different forums but none of them worked, need urgent help on this issue. Thank you !

P.S I am utilizing the latest version of the On-Premises Gateway.

[gvg]

@Anonymous , did you try point 2 as suggested by @v-yaningy-msft? 

[Anonymous]

Hi, @Anonymous 

Based on your description, you are experiencing issues when refreshing Power BI reports. The error code usually indicates a timeout issue during query execution. Here are some solutions you can try (be sure to back up your data before making any changes).

1. Increase the CommandTimeout and ConnectionTimeout parameters. The default value for CommandTimeout is 10 minutes and the default value for ConnectionTimeout depends on the driver. These values can be changed in Power Query.

Related link:Solved: DM_GWPipeline_Gateway_TimeoutError - Microsoft Fabric Community

2. Check the resources of the computer running the gateway to ensure that the computer running the gateway has enough hard disk space and available RAM.

3. Look at the data model and queries. Large, complex data models or inefficient queries may cause timeouts. Consider optimizing data models and queries to improve performance.

4. Network latency or instability may cause a timeout. If possible, test with an alternative network connection to see if the problem persists.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[aj1973]

Hi @Anonymous 

In the Table : de_transaction , do you have calculated columns?

[Anonymous]

Yes I do

[aj1973]

Calculated Columns and Calculated Tables need to be avoided as much as possible. Add Calculated only when it is necessary to use as a filter category for exemple.

So go back to your desktop and start analysing which one is causing the Time out and replace it or replace all of the calculated columns by Measures.