Forum Discussion
Automated refresh Sharepoint Folder Data Source
if possible.
if your report already has visualizations and data customizations that you don't want to lose. I recommend the following:
1. Connect to the folder in SharePoint Online and perform the tranbsforming steps to unify the files into a single table.
2. Enter the advanced SharePoint connection editor and copy from the second line to the penultimate line.
3. Duplicate the original table (test backup only). it's all over it.
4. In the original table (Local Folder) enter the advanced editor and change the connection steps to the data sources by the steps you copied from the connection to the SharePoint folder. the other transformation steps you have you should leave them. make sure to validate steps, commas, separators and so on.
5. Apply changes and test.
That is really good approach. However I am facing problems where there will be lets say 10 data input (10 folders) and each folders has multiple versions. This version will be changed over time depending on the scenario that we want to run in the dashboard. the reason I can not combine the file because each folder have different confidentialities. there will be multiple person with different authorization to update or change each folder. do you have different approach? thank you very much