I have installed Power BI Desktop in my machine ..and connected my SharePoint list with it..
I have also created the Graph, Charts using Power BI..
How Can I automate the data refresh for my dashboard chart, Graph from the SP Lists..
Any Article or Video???
Automatic refresh is not available within Power BI Desktop
The only refresh option within BI Desktop is the manual Refresh you find in the top ribbon
Check out the following link for more information on data refresh:
If you require automatic refresh of your data, I would suggest publishing your report and looking into setting up a scheduled refresh.
More information on this is included in the link provided above.
I've written a post describes the use of a 3rd party tool (AxioWorks SQList) to synch the SharePoint lists with normalised SQL Azure tables which then gives you the option of direct query via SQL Azure for a more real time(ish) update.
Since SQList updates SQL Azure as soon as SharePoint changes are made it is a very nice workaround for Direct Query to the 8 updates limitation