Refresh Error

[aakkem]

Hello,
Im getting a PowerBI refresh error, you can find the error in below attached. Can anyone advise about this error.

Thanks,
Akhil


Im getting this PowerBI refresh error

[ibarrau]

Hi. It looks like the data you are getting is taking quite time to respond. It throughs a time out because it's taking to long. By default power query has a 15 minutes for execution. You can increase that in Power Query code. The source step in the query (advance editor or formula bar).

The function has command time out to increase as a duration item: https://docs.microsoft.com/en-us/powerquery-m/sql-databases

You can also do it in the UI when you connect for the first time. Examples:
https://community.powerbi.com/t5/Desktop/How-to-set-command-timeout-option/m-p/487941

I hope that helps,

P/D If the query takes 2 hours it won't refresh, it's a pro license limitation.