Forum Discussion
Automate Refresh button in Power BI Desktop
I have started using PowerBI DEsktop, using In House MS SqlSErver as data source
When I enter app, I always need to click the Refreh button to refresh the data
THis can take up to an hour
I would like to have this done in an automated script overnight, so when I come in in th emorning, the data has been refreshed
1. Is this possible
2. If it is possible, do I have to pay for this service
4 Replies
See this thread, it presents a couple different options both free and paid:
http://prologika.com/automating-power-bi-desktop-refresh/
Just stared using PowerBI with inhouse Sql Server
I dont publish to web, just use from my own desktop
Everytime the data chnages though, I have to click the 'Refreh' button, whcih can take 30 minutes
I would like to have this done at night, so when I go inot PowerBI, it is showing latest figures and graphs
1. Is this possible ?
2. I an using Free Version, so will this cost anything ?
Hi will2018,
It's impossble to refresh automatically to date, please review the following feature request and vote it. Project Team will consider it if more people vote it. Power BI wll become better after your support.
Auto refresh data in Power BI desktop
Best Regards,
Angelia
You can use Auto IT. A small bot can be used to fetch the Windows Handler ID, make it as active window and you can use Keyboard shortcut to navigate the Refresh (Send Keys function) until Microsoft gives us option to Auto Refresh for PBI Desktop.
