Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Im getting a PowerBI refresh error, you can find the error in below attached. Can anyone advise about this error.
Thanks,
Akhil
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.
Happy to help!