Refresh Error

aakkem · ‎04-19-2022

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 · ‎04-19-2022

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.

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

Happy to help!

LaDataWeb Blog