Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper III
Helper III

Power BI Premium and direct query

Hi everyone,


I have a few questions regarding direct query reports in Power BI Premium:

1.) In this documentation, there is a limit of Direct Query / Live connections (per second) stated for each type of Premium capacity (e.g. 60 for PC). 

What exactly does that mean? Is it the number of concurrent users using a direct query connection to any database?
Or the number of querys towards the database? Each visual can generate several queries, so that one report could easily reach that margin.

2.) In the admin settings of Power BI Premium Capacity, you can specify a timeout margin, which defaults to 3.600 seconds - this is also our setting. However, we have experience that most queries time out at 225 seconds. 
Does anyone know where this value can be configured, or what is the reason for this specific value?

Community Support
Community Support

Hi @IMett ,

Here are the answers to the two questions you asked:
1. The P2 corresponds to 60 which mentioned in the document is the number of DirectQuery and Live Connection connections per second

Capacity nodes
2.There are several limitations when use DirectQuery/LiveConnect mode. Such as a one-million-row limit for returning data and a 225 seconds response time limit for running queries. You can find the details in the following official documentations.

Data refresh in Power BI

Important considerations when using DirectQuery

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yiruan-msft , thanks for your reply. 
The 2nd question is solved so far, thank you for the helpful documentation link. 


For the 1st question, I still do not really understand what exactly a connection is in this context...

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors