Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.