Our current approach :
We use one drive to check in and check out power bi files for coordinating between deveopers (BI Team) and then there by connecting power bi files from power bi service to one drive. We would also like to enable business users to built their own reports in workspaces and there by sharing and distributing via power bi app. Source for power bi is SSAS.
My Conerns:
1.If the business user edit the report in service which was connected to power bi fle in one drive then it's going to break the link between service and one drive for that file which we don't want to happen (work around we are educating the business users not to edit the files that were published by BI team). Every time that wanted to built reports we told them to go to data sets tab and then add report from the corresponding data set. How to enforce either not to break the link between service and one drive or how to sync one drive file to the changes that were made in power bi serivce ?
2. We have backup files for the ones that BI team built in one drive just in case if some one accidentally delete a report but what about the reports that where created by business users ? We can't take backup of the files when ever business user built a report.
Please share if you have any thoughts that would make by scenario better ? Thanks!
