Forum Discussion
Auto page refresh - Power BI App
Hi all,
I am looking at creating a report which would display publicly. The data in the report would refresh every 10 minutes so I would need the report to automatically refresh once the new data is received. What is the best option to achieve this?
Many thanks in advance 🙂
Hi Anonymous ,
You can create a PowerShell script to invoke the Power BI dataset refresh using Rest API
https://technovert.com/blog/refreshing-all-datasets-in-power-bi-using-rest-api/
This is the related document, you can view this content:
https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
https://altis.com.au/greater-control-of-your-power-bi-datasets-with-the-power-bi-rest-api/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Anonymous with the direct query you can have minimum of 30 minutes, but if you are using premium then it can be every second. Read more here Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hello
My sugestion:
- live streaming dataset -> https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
- Direct Query -> https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Any question ask.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Best Regards
BCHi Anonymous ,
You can create a PowerShell script to invoke the Power BI dataset refresh using Rest API
https://technovert.com/blog/refreshing-all-datasets-in-power-bi-using-rest-api/
This is the related document, you can view this content:
https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
https://altis.com.au/greater-control-of-your-power-bi-datasets-with-the-power-bi-rest-api/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
