Visual Times out

Hi Heinrich,

If the visual times out it is due to the measure or model taking too long to bring the required data.

I suggest that in Power Query you ensure that you have pulled the columns you need, this will ensure that the model size is reduced and enhances refresh speed.

If the visual is using a measure make sure it is aggregated in DAX using SUMX for example.

Hope this helps in finding a way to make this visual load swiftly.

Hi Heinrich,

If you don't mind some questions to debug the problem:

• Is the time out in the service or in Power BI Desktop?
• What is the visualization you are trying to use?
• Do you get any additional message than the time out message?
• Can you also provide what is the data size that you are using for your DQ? (row number)

Hi Heinrich Seems like you are in development stage. So, in Power BI Desktop default timeout limit is 225 Seconds and memory limit is 1 GB. If your query exceed the available resource you will get an error. So, the best way is to filter the data as much possible and keep only required columns with proper data type. 

Even, You can try with Custom timeout or No Query Limit from here 

Power BI Desktop -> File -> Options and Settings -> Options -> 

Here is the details: Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn 

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

Hi Heinrich 

Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to Azzam_Alnatsheh  , Royel  and MFelix  for offering helpful suggestions.

Could you let us know if the suggested solution resolved your issue?If you still need help, please share more details so we can assist you further.

Thank you.

Hi Heinrich 

Just checking in as we haven't received a response to our previous message. Were you able to review the information above? Let us know if you have any additional questions.

Thank You.

Hi Heinrich 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

Hello 
Hope you are all doing well.

I have these configurations or details

• No query limits
• Time out is on Power BI Desktop
• The type of visualization is "table" pulling 3 columns of a direct query database (not possible to switch to import mode)
• No additional message in the error
• The row number would be at least ~200k
• I tried to filter as much as possible but no luck

Thanks for your support

Regards
Heinrich

v-karpurapud 
MFelix 
Royel 
Azzam_Alnatsheh 
Thank you very much for your help.
Wish you a great day
Heinrich