Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Timeout issue

Can you interpret this for me and what the typical reason mitght be:

 

Behandlingsfeil: Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Klynge-URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Aktivitets-ID: 9b81f530-88e4-4fbd-be58-03c69d16c4d3
Forespørsels-ID: e7690db4-43c1-c600-37bf-1e304b2a8294
Klokkeslett: 2022-06-13 08:47:35Z

Status: Investigating

Hi @EvenMyrvold.,

 

This issue is very likely that data query isn’t completed by the SQL data source but the query time has reached the limitation. In other words, the data source is not able to handle the requests/queries within the timeout time.

You may try this solution: prolong the command timeout in Power BI connector dialog or configure it in the data source itself.

vcazhengmsft_1-1655186719400.png

 

Or you may consider reduce the data amount used in the report to reduce the queries.

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

Hi @EvenMyrvold.,

 

This issue is very likely that data query isn’t completed by the SQL data source but the query time has reached the limitation. In other words, the data source is not able to handle the requests/queries within the timeout time.

You may try this solution: prolong the command timeout in Power BI connector dialog or configure it in the data source itself.

vcazhengmsft_1-1655186719400.png

 

Or you may consider reduce the data amount used in the report to reduce the queries.

 

Best Regards,

Community Support Team _ Caiyun