Forum Discussion
SharePoint Folder - receives updated extracts every 2 weeks and replaces the old extracts
- 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.
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.