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 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!
- Anonymous6 years ago
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.
2 Replies
- v-lid-msftCommunity Support
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, - AnonymousNot applicable
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.