Forum Discussion
Automatically update Power BI from Sharepoint
Hello I have a .pbix published in my work environment with data in sharepoint. Does not update the environment every hour, what can be the cause? sharepoint updates in PBI every hour?
Anonymous ,
Do you connect to SharePoint online files such as csv or Excel in Power BI Desktop? And do you want to get updated data in Power BI report when you change data in the file data source within one hour? If so, you would need to directly connect to the SharePoint online file in Power BI Service using Get Data->Files->SharePoint option. Then create report in Power BI Service and configure OneDrive Refresh for the dataset.
Regards,
Lydia
Hi Anonymous,
It's also possible to update the dataset via Azure Logic Apps (and possibly PowerApps/Flow). You can set it up like this:
- Add a Recurrence as trigger and select an interval
- Search for the PowerBi connectors and select 'Refresh a dataset'
- Connect the PowerBi Workspace and Dataset