Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 manual refresh is also failing failed again.
-->I tried to increase.command timeout for table causing issue, but still not working.
--> I tried to refresh report on power Bi desktop but no luck.
--> I tried to reduce data also.
Please help regarding the same.
Thanks in Advance!
Solved! Go to Solution.
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.
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,
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 37 | |
| 18 | |
| 14 |