Forum Discussion

skthomas2010's avatar
skthomas2010
New Member
1 year ago
Solved

SharePoint Folder - receives updated extracts every 2 weeks and replaces the old extracts

I am trying to create a Power BI report that is connected to a SharePoint Site/Folder.  The folder "Latest Reports" has 6 different extracts with different information within each.  All extracts ar...
  • Akash_Varuna's avatar
    1 year ago

    Hi skthomas2010 Use the SharePoint Folder option in Get Data and filter the folder path to include only the "Latest Reports" files. Combine and transform the files, ensuring consistent structure across all extracts. When new files replace old ones every two weeks, Power BI will automatically detect and load the updated files during a refresh. Publish to the Power BI Service for automated refresh schedules or refresh manually in Desktop as needed.