Power Bi refresh Failed

[Anonymous]

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!

[Anonymous · Accepted 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.

[v-lid-msft]

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,