Forum Discussion
How can I use Python to schedule a data refresh?
I understand that there are limits to the amount of scheduled refreshes one can make when following the traditional route with no coding. Is there a way to write a python script to schedule a data refresh?. If so, how can I go about doing this?.,
Thanks in advance.
Hi HamidBee ,
You could use the "refreshes" API endpoint in Power BI. Here a blog post on this:
https://pbi-guy.com/2022/01/07/refresh-a-power-bi-dataset-with-python/
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
2 Replies
Hi HamidBee ,
You could use the "refreshes" API endpoint in Power BI. Here a blog post on this:
https://pbi-guy.com/2022/01/07/refresh-a-power-bi-dataset-with-python/
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/Thanks for the link. I'll go through it carefully. The only thing that I was dissapointed to learn was this part
"Keep in mind that the limitation of your licensing can’t be eliminated. This means if you’re using the Power BI Free license you can programmatically refresh a dataset once a day. With a Pro License it’s eight times a day, and with Premium or Premium per User it’s 48 (see https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#data-refresh)."
I was hoping Python would eliminate this limitation entirely.
