Forum Discussion
Automatic refresh for an entire folder in Sharepoint
Hello,
Is it possible, once you have linked Power BI to a folder in SharePoint, to add additional files to that folder and have them automatically connect/refresh to your Power BI?
NateL,
You can filter the path to the sharepoint folder after importing data to Power BI Desktop in Query Editor, expand the content column, create report in Power BI Desktop to Power BI Service.
Then you can schedule refresh for the dataset in Power BI Service, this way, when you add additional files to the SharePoint folder, the dataset and report in Power BI Service will get updated automatically based on the schedule.
Regards,
Lydia
3 Replies
Perhaps taking some of the ideas from this article might give you some clues what you might be able to do?
NateL,
You can filter the path to the sharepoint folder after importing data to Power BI Desktop in Query Editor, expand the content column, create report in Power BI Desktop to Power BI Service.
Then you can schedule refresh for the dataset in Power BI Service, this way, when you add additional files to the SharePoint folder, the dataset and report in Power BI Service will get updated automatically based on the schedule.
Regards,
Lydia