Forum Discussion
How to Auto refresh data in Power BI Desktop from SharePoint List
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 fo...
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