Forum Discussion

maazbinsalman99's avatar
maazbinsalman99
Frequent Visitor
1 year ago
Solved

Best Collaboration Options for Reports

Hi Team

I am making a central report on PowerBI. This report is a joint venture of two analysts working on different domains. We are looking for a solution where we both can make changes to the reports, either the visual changes or the changes in data model. Is PowerBI service a good option and what are its limitations. Is there any other way?

  • Hi maazbinsalman99 

     

    The only way I can think of doing this that will work is you have both of the report authors connecting to the semantic model where they develop each of the pages themselves in their own PBIX. Then once it is ready you copy all the visuals in each page from one open PBIX to another open PBIX. You can do this. Because when it copies across it will look for the columns and measures which will exist in both of them. I know it is a bit manual but that is the only way I can recommend getting this done.

  • - Best Option: Power BI Service with shared workspace—both analysts can edit and publish, but not simultaneously. Use OneDrive/SharePoint for version control.
    - Advanced Option: Save as .pbip and use Git for branching and merging—great for version tracking but needs discipline.
    - Simple Option: Split report into sections, build separately, then manually merge—works but not scalable.
    - Pro Tip: Centralize the data model as a shared dataset, then build visuals independently.