Forum Discussion
Solved
How to refresh data between SharePoint Online List and embedded PowerBI dashboard
Hi all, Sorry if this is a basic question but I have created a Power BI Dashboard using data from a SharePoint online list. I then embedded this dashboard onto a SharePoint site and set up a sche...
lampard1987 Then you will need to manually refresh. As outlined here Direct Query to Azure SQL DB or Warehouse are the only supported data sources that handle seeing fresh data. Since you are importing the data into the PBIX, there is no mechanism like the Power BI Service provides in offering refresh. My assumption is that with the support of the gateway in the future that this will be possible.
Here's a blog post that I've written that describes the use of a 3rd party tool (AxioWorks SQList) to synch the SharePoint lists with nromalised SQL Azure tables which then gives you the option of direct query.
Since SQList updates SQL Azure as soon as SharePoint changes are made it is a very nice workaround for Direct Query