Forum Discussion

NateL's avatar
NateL
New Member
8 years ago
Solved

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?
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Nothing here is helpful at all