Time out error in Power BI desktop

[Anonymous]

I have many queries in the power i report, and i have also set up command timeout, But still when i try to refresh it fails with MSSql timeout error for one particular table. This also effects my report on service portal. what could be causing this

The File size is about 55MB.

Also how do you decide how much  Command timeout should be ?

[Anonymous · Accepted solution]

The Power BI service has a hard limit of 120 minutes, so there is no point setting anything above that amount.

I set a lot of a my queries to 90 minutes and its often enough to handle the off/on peak variance.

This shouldn't be a bandaid fix for poorly optimised queries however.  So if you have a query that is taking a very long time to run, always consider whether this query could be optimised in some manner.