Forum Discussion
Power BI Desktop Timeout expired.
Community Championthe first place i would start is by trying to reduce what i am bring back if possible, ie. are you bringing back more than you should, just bring back the columns and range of data that you need.
Also check things like data types, i am not sure how much control you have over that, but obviously bring back less might help with the timeout. If you have huge text columns that dont need to be text or could be smaller that will have an impact.
Are you doing a lot of tranformations on the data, try to do that in SQl as much as possible. i.e server side
Do you have indexes on your tables?
Is it direct query or imported?
Is it intermittent or does it do this every time?
Well, Thank you for your advice..
yes all calculations are done in SQL, i just receive the final raw data to be used directly without any calculations nor measure on power bi.
No indexes yet, but i thought of adding indexes to improve performance since it takes ages to draw visuals and filter it (as i use the direct query method).
Well, I have changed something that would have been the cause of this issue. as this problem happened after downgrading the Azure SQL Plan from the Premuim one to the standard S1, this means reducing the OLTP of the SQL DB for less DTUs.
Would that affect the pool size? and cause such a issue ?I'm not sure..