Forum Discussion

Spriinter's avatar
Spriinter
Frequent Visitor
4 years ago

Power BI Refresh Frequency

I hope to display my Power BI report on a screen and refresh it very frequently (e.g. every 5 mins). My report connects to the SQL Server Database (on-premises gateway, "Import" method) and my accoun...
on-premises gateway
Refreshing
SQL Server Database
Spriinter's avatar
Spriinter
Frequent Visitor
4 years ago

Hello Jon-Heide,

Thank you for the answer. Yes, I have experimented DirectQuery mode and the Automatic Page Refresh function. In DirectQuery it did refresh more frequently than Import, but another problem happened.

I set the Automatic Page Refresh of my report to "1 Minute" but when I publish this report to Power BI service, the most frequent refresh interval for my dataset is every 15 minutes. In case that I wish my report to refresh more frequently, is there a solution?

 

Thank you!

 

David Meng

alicegray's avatar
alicegray
Helper I
1 year ago

Hey! 
It’s possible to enable real-time report refresh capability in your Power BI Pro account. Here are some of the best ways: 


• Use DirectQuery – By implementing DirectQuery API in your Power BI account, your reports deliver up-to-date information without storing data in the internal storage. 


• Configure Scheduled Refresh – In your Power BI workspace, you can configure the frequency of report refresh within the Scheduled Refresh section. 


• Create Push Dataset API – By using PowerShell, you can create a custom push dataset API and integrate them with your reports, enabling real-time streaming and refreshing options.