Forum Discussion

ZLJ's avatar
ZLJ
Advocate II
9 years ago

Report writing responsibilities

Does anyone split report writing responsiblities between different departments?  How do you manage this in Power BI?

 

Ideally we would like IT to be responsible for writing all Queries and designing some reports.  However, we want another team to be able to add custom formulas and change the layout of the reports without going through IT.  

 

Currently if they make these changes in Service, then the next time IT update the query, these changes would be overwriten.  So until there is a way to export the reports from Service back to Desktop, all changes need to be made in Desktop.  This means that access to the PBIX files needs to be shared which starts to get messy, and also means they have access to Edit Query as we cannot restrict it.  

 

Does anyone have a solution to this?  Has anyone round a better way to split these responsiblities?

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi ZLJ,

    From my point of view, all departments can make changes on a shared PBIX file, however, you’d better use Git or SVN to do full version control on the shared PBIX file, this way, every department is able to make changes on the synced and updated PBIX file. Moreover, using Git or SVN, you can revert to a previous version of PBIX file.

    In addition, as stated by Kim in this idea, power bi team is working on the feature that download reports from Service to local PBIX file. Once the feature is available, it would be easy for you to split report writing responsibilities.

    Thanks,
    Lydia Zhang

    • ZLJ's avatar
      ZLJ
      Advocate II
      9 years ago

      Thanks Anonymous Ideally i want to avoid giving the other team any access to Desktop, as they do not have the skills and i'm worried about what they could do if they go in there.  Fingers crossed the ability to download pbix files is developed soon, as that would solve the problem...