Forum Discussion
Power BI premium workspace refresh rate clarification
Hi henrychoiyw
You're correct that in a Power BI Premium workspace, scheduled refreshes are limited to 48 refreshes per dataset per day. However, this limitation applies to import mode datasets.
For DirectQuery and Live Connection modes, there is no limitation on the number of refreshes, as these modes query the underlying data source in real time (or near real time). When users interact with a report based on DirectQuery, Power BI sends queries to the data source on-demand, so there’s no need for scheduled refreshes.
However, keep in mind that the performance of DirectQuery depends on the responsiveness of the underlying data source, and frequent queries can impact performance if the data source is slow or under heavy load.
In summary:
- Import mode: Limited to 48 refreshes per day per dataset.
- DirectQuery: No refresh limit, but performance depends on the data source. You can achieve near real-time reporting this way.
This makes DirectQuery a suitable choice for your "nearly real-time" event registration report.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Super UserHi henrychoiyw
You're correct that in a Power BI Premium workspace, scheduled refreshes are limited to 48 refreshes per dataset per day. However, this limitation applies to import mode datasets.
For DirectQuery and Live Connection modes, there is no limitation on the number of refreshes, as these modes query the underlying data source in real time (or near real time). When users interact with a report based on DirectQuery, Power BI sends queries to the data source on-demand, so there’s no need for scheduled refreshes.
However, keep in mind that the performance of DirectQuery depends on the responsiveness of the underlying data source, and frequent queries can impact performance if the data source is slow or under heavy load.
In summary:
- Import mode: Limited to 48 refreshes per day per dataset.
- DirectQuery: No refresh limit, but performance depends on the data source. You can achieve near real-time reporting this way.
This makes DirectQuery a suitable choice for your "nearly real-time" event registration report.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Rita,
Thank you very much for your reply.
I want to ask one more thing, if the datasource is Dataverse, is DirectQuery still no refresh limit?
Henry
- Ritaf1983
Hi henrychoiyw
Yes refreshes limitations are the function of import mode , when using DirectQuery mode with Dataverse ( or others )as your data source, there is no refresh limit in the traditional sense, as the data is queried in real-time directly from Dataverse. DirectQuery doesn’t cache data but sends queries to the data source when interacting with the report, so the need for scheduled refreshes is eliminated. However, you should be mindful of potential performance impacts, especially with complex queries or large datasets, as each interaction results in a live query to the Dataverse.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly