Forum Discussion
Power Bi refresh Failed
Hi Developers, I am facing issue from Past few days, My scheduled refresh is failing due to the above message :- -->I tried to refresh it manually for few days it worked but today manu...
The issue was a clumsy huge query, i removed it and wrote a simpler query, which solved the issue. Also, i increased the command timeout period to 120 mins.
Hi Anonymous ,
If you have increase the timeout for Sql.Database function in Power Query Editor, Please also check the query time out properties on the Sql Server side and then set the timeout in your power query editor(such as up to 120 minutes)
Please refer to this similar thread: https://community.powerbi.com/t5/Service/MS-SQL-server-timeout/td-p/375307
Best regards,