Forum Discussion
How to refresh PBI automatically ?
Hi All
my raw data put at sharepoint ,
and i refer to below you tube , it can auto refresh data by script.
Does any one know can share the script ?
Paul
Hi Husna
Thank you for help me looking into my issue , appreciate very much.
in cannot paste image here , because i have paste too many image in the past. so i can only share the image link :-
https://www.dropbox.com/s/tytko8wtvkzsogd/refresh%20icon.png?dl=0
Above is the image where i click on the refresh.
https://www.dropbox.com/s/f0m6xlr6ux00wyn/error%20msg.png?dl=0
Above link is the error msg.
Hope you can advise me how to clear the error msg ?
Edit :- I just try and found out that due to one of the XLS file cause problem , after i disable this file to load , and it can refresh without any issue. Now case closed
Paul
6 Replies
Hello Anonymous ,
Although it is best to use the scheduler in PowerBi service for the auto-refresh, the following 2 links will probably help you refresh the pbix using a script.
The first link uses a VBS script for excel but i suppose you can change it to cover your needs in PowerBI
https://github.com/IvanBond/Power-Refresh-VBScript
The second link has a refresher created in python (python script).
https://github.com/dubravcik/pbixrefresher-python
In both cases it requires some basic knowledge on script writing
Anonymous
If you are a PRO user you can log on PowerBI Service (https://powerbi.microsoft.com/en-us/landing/signin/) using your credentials, publish the report to the service and add the scheduler.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
