Forum Discussion

Sivanesan's avatar
Sivanesan
Regular Visitor
2 years ago

Power BI refresh error : Dedicated SQL Pool: Execution Timeout Expired.

Hi Everyone   I am getting below error while refreshing one of my dashboard(For a single view) in both service and Dekstop. Datasource is Dedicated SQL Pool.   Data source error: [ValidateMarkupT...
Need Help
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
2 years ago

Hi. By default the SQL Server or SQL sources have a timeout of 10 minutes. So if your query is taking longer, you need to increase that value or check if you can optimize the response from the BD.

In order to increase the timeout you can read the power query source step function like: https://learn.microsoft.com/en-us/powerquery-m/sql-database

The commandTimeout is the key parameter. If I'm correct, it's something like this:

Sql.Database(server as text, database as text, [CommandTimeout = #duration(0,0,30,0)] )

 Duration it's configured for 30 minutes in that example.

I hope that helps,