Forum Discussion
Power BI Premium Per User - Can't schedule 15 mins increments
Thanks for the reply from lbendlin please allow me to provide another insight:
Hi, Anonymous
Regarding the issue you raised, my solution is as follows:
1.As bendlin mentioned, to overcome refresh limitations, you can utilise certain tools, which will require your team to have a foundational understanding of code development.
A more effective approach would be to combine the Power BI REST API with Power Automate. You can also perform similar operations with XMLA. By using the Power BI REST API or XMLA endpoints, you can write scripts to trigger refresh operations more frequently and create new automated workflows with Power Automate.
During this process, you can add triggers, such as a "timer" trigger, setting it to activate every five minutes to execute the report refresh.
For further details, please refer to:
Solved: Power BI Data set Refresh using Azure Functions wi... - Microsoft Fabric Community
How to Refresh Power BI Dataset Using Power Automate
Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn
Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Get started with triggers - Power Automate | Microsoft Learn
2.Additionally, you can leverage Azure Functions to refresh reports. These tools can be integrated to achieve high-frequency automatic refreshes.
For more information, please refer to:
Solved: Power BI Data set Refresh using Azure Functions wi... - Microsoft Fabric Community
As I mentioned earlier, this method of controlling refresh operations through code scripts requires users to have development experience. Therefore, if needed, you may collaborate with team members who are proficient in coding.
3.Of course, you might also consider storing your data in a database that supports DirectQuery connections, allowing you to use page refresh:
Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.