Forum Discussion

rftanner's avatar
rftanner
Frequent Visitor
1 year ago

Sharing or coauthoring dataflows

Reading this article, I ran into a show stopper for me.  

 

Security roles and permission levels in standard dataflows - Power Query | Microsoft Learn

 

Even after looking for proposed workarounds, it still is just too cumbersome.  PowerBI can dataflows be shared - Google Search.   Nor does any administrator want to follow this path.  Come On Microsoft.  Why?!   is there BETTER way????   Dataflows was suppose to be a gamechanger for me in developing 'one source of truth', code reuse, making my life easier, etc etc........any help MUCH appreciated.  

 

Currently, it's not possible for two different users to collaborate on the same dataflow. Only the creator (owner) of the dataflow can edit it. In the event a dataflow needs to be transferred to a different user, an environment administrator can change the owner of the dataflow from one user to another, as long as the current owner is still a member of the organization. For security reasons, transferring ownership removes the connection associated with the dataflow and requires the new owner to update the credentials used by the dataflow.

 

BASIC ISSUE:  Question (to reply to senior mgmt):  can you share PowerBI dataflows?  meaning.....can a dataflow have more than one owner?  example:  If I'm not available, can another administrator edit my dataflows?  if so, how?  I need a clear answer here for management and next steps.   Thanks Much.   

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi rftanner ,
    According to your description, the data stream currently does not support having several owners or several people operating on it. This is to ensure the security and integrity of the data, Power BI only allows the creator of the data stream to make edits. This prevents unauthorized changes and potential data leakage. As you can see from the documentation, you can transfer the permissions of this data flow and reconfigure the credentials if needed.
    You can submit an idea for it at:Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

     

    Best regards,
    Albert He


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • rftanner's avatar
      rftanner
      Frequent Visitor

      Thanks so much. I will definitely do that because I think it is very much needed for large data organization groups that manage data streams