Forum Discussion
Multi-user collaboration on a pbix
Anonymous Generally the way that I have seen this work best is to separate the data model from the report development so that one person works on each. So, in a PBIX file, create your data model with no report and publish to the Service. Then, create a second PBIX file and connect to the published Power BI dataset in the Service. Create your visuals in that report. This separates the duties of the data modeler from the report developer allowing both to occur in parallel.
Super UserHi Anonymous ,
Multiple Users can work on a same file if it is shared in Sharepoint. But the file is not directly editable in sharepoint. It has to be downloaded and opened with Power BI Desktop.
Post modifying the report this has to be uploaded back to the SVN replacing the earlier file. But be aware, I would not recommend this as this involves high possibility of losing the changes if multiple users work at the same time.
Instead the same approach of sharing the file with multiple users by downloading in their desktop app can be used provided the file is placed in some version control tool that gives you possibility to lock the file being modified.
FYI, here again PBIX is not editable directly and hence will have to be opened with Desktop app post downloading it
We have encountered similar issues where the datamodel has been version controlled; however, report development on PBIX is to be undertaken by multiple users. Even if the PBIX file is hosted on the SharePoint, it is editable only in the local desktop version, thereby losing its shared functionality and losing out on the updates made by other users.
Recommending Microsoft to look into this issue and enhance PBIX file capability where multiple users work on one file at the same time in their upcoming releases.