Forum Discussion
Automated refresh Sharepoint Folder Data Source
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
if the idea is to upload files from different folders, but let each one be independent.
the focus is the same, only repeated 10 times.
The fact that different users upload information to folders according to their security levels, is indifferent to Power BI. Power BI must have access to all 10 SharePoint folders and be able to map the data separately or together.
at the report's visuaization level, you can use role-by-role security so that each user only has access to the corresponding data (requires PRO license)