time limit on queries

Hi powerbiexpert22 ,

 

Thank you for reaching out to Microsoft Fabric Community forum.

Greg_Deckler Thank you for your quick response.

 

Not directly. Power BI doesn't let admins set hard timeouts for DirectQuery queries inside the platform itself.

However, timeouts can be influenced through:

• Gateway Settings (for on-prem data):
  You can adjust the timeout in the On-Premises Data Gateway config file (default: 2 minutes).
• Database Server Timeouts:
  DB admins can set query timeouts in the data source (like SQL Server or Oracle).
• Performance Optimizations:
• Reduce visuals and filters in reports
• Use aggregations or hybrid models
• Tune DAX/SQL to avoid heavy queries

 

Regards,

B Manikanteswara Reddy