Forum Discussion
Multiple users working on same pbix file
Hi Franklin,
We haven't found a good alternative way where I work - we do what you're doing.
One small piece of advice is that you could be saving the file as a PBIT instead of PBIX as if you're bringing a lot of data into the model your different versions will end up taking up a lot of space.
PBIT does mean that the model will need to load the data every time you open, so it's a bit of a trade-off.
Alex
Hi fherrera ,
I have run into this same conundrum. I have 2 options for you to investigate.
1. Use a sharepoint site and document library and enable versioning control as this may help with the versioning aspect of your question, this will also all for check in and check out of the pbix file to ensure there are no edits made by a person when they are not meant to be working on it.
2. And this is my preferred way of working. Have the Data Modeller publish the work he has completed, then you can connect to the PowerBI dataset and create your report. This will allow you both to work collaboratively on different aspects of the same Data/Report.
Hope this helps.
David
This seems to be the only way to work when you need to do things in the .pbix file. My user is very adept with data and modeling but she can't do the tricky DAX or OLAP functions. I enabled that for her but her experience is with EXCEL and her fallback method of use is to work like in Excel.
I think versioning and check in check out is the best way to work.