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.
Hello Everyone! Can someone please clarify on this, I think I am missing something:
The automatic page refresh is avaliable with direct query, and can be set to refresh the report in as little as 2 seconds. But what good is it for, since the Direct Query itself can be updated just every 15 minutes?
Thanks,
Solved! Go to Solution.
Hi @Anonymous ,
When automatic page refresh is enabled, Power BI Desktop is constantly sending queries to your DirectQuery source. After the query is sent, there's a delay before data is returned. So, for short refresh intervals, you should confirm that queries are successfully returning the queried data within the configured interval. If data isn't returned within the interval, visuals will update less frequently than configured.
As a best practice, the refresh interval should at least match your expected new data arrival rate:
For low refresh intervals like one second, take factors like the following into consideration:
In addition, the Direct Query itself can't be updated every 15 minutes, you may need to enter the duration interval in automatic page refresh page.
You can estimate return times by using Performance Analyzer in Power BI Desktop. See more details: Automatic page refresh in Power BI Desktop.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
When automatic page refresh is enabled, Power BI Desktop is constantly sending queries to your DirectQuery source. After the query is sent, there's a delay before data is returned. So, for short refresh intervals, you should confirm that queries are successfully returning the queried data within the configured interval. If data isn't returned within the interval, visuals will update less frequently than configured.
As a best practice, the refresh interval should at least match your expected new data arrival rate:
For low refresh intervals like one second, take factors like the following into consideration:
In addition, the Direct Query itself can't be updated every 15 minutes, you may need to enter the duration interval in automatic page refresh page.
You can estimate return times by using Performance Analyzer in Power BI Desktop. See more details: Automatic page refresh in Power BI Desktop.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.