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.
Hi all,
Where do I reference to when I want to show the next scheduled refresh time in my dashboard?
Is there a way to also see if the last refresh had any issues?
Solved! Go to Solution.
Hi @IAM ,
1.To my knowledge, there is no direct methods to get the next refresh time in Power BI . So I agree with @tackytechtom that you need to use Rest API to do such thing.
2. For refresh details, If you are a Power BI Admin, you can click the gear icon in the upper right corner of the service page and select the "Admin Portal" option. Find the Refresh summary menu, click on the History tab, and then click on "Export" to download and refresh the history.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi y'all,
Just wanted drop this one here, where I wrote a blog article on how to expose the next schedule refresh date/time in a Power BI report. It uses the get-refresh-schedule REST API to load in the schedule data and calculates the next scheduled refresh with a measure:
https://www.tackytech.blog/how-to-get-the-next-scheduled-refresh-date-into-your-power-bi-report/
Hope this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @IAM ,
1.To my knowledge, there is no direct methods to get the next refresh time in Power BI . So I agree with @tackytechtom that you need to use Rest API to do such thing.
2. For refresh details, If you are a Power BI Admin, you can click the gear icon in the upper right corner of the service page and select the "Admin Portal" option. Find the Refresh summary menu, click on the History tab, and then click on "Export" to download and refresh the history.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there a more easy way? Because with this I need to use the powershell right?
Hi @IAM ,
You might be able to calculate the next schedule refresh with this API:
Datasets - Get Refresh Schedule - REST API (Power BI Power BI REST APIs) | Microsoft Docs
To get information about recent refreshes, I would probably use this one:
Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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.