Forum Discussion

jsangerman's avatar
jsangerman
Helper II
3 years ago

Can't use dataflows from other users in Power Query

I have created dataflows in a workspace I manage. I have no problem connecting to those using either the legacy Power BI Dataflows connector or the "new" Power Platform connector.   However, someon...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi jsangerman 

 

Based on my research, a dataflow is not able to be shared with other people directly like we share a dataset with others. The only workaround I found is that the person that wants to use a dataflow created by others should be added to the workspace where the dataflow is located. He can be added as a Viewer role, which is enable for him to connect to this dataflow. With only Viewer role, he cannot edit the dataflow or edit the workspace. 

 

So you need to let your colleague add you to the dataflow's workspace as a Viewer role, then you are able to see this dataflow in Excel using the Power Platform dataflow connector. 

 

Reference: the 7th message from How do I share read access to a Dataflow? - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • jsangerman's avatar
    jsangerman
    Helper II
    3 years ago

    Thanks for the response, Jing.

    That doesn't seem right, though. First, it conflicts with the stated purpose of dataflows, which is to share prepared data. In fact, from the Learn page Configure and consume a dataflow - Power BI | Microsoft Learn, we find this note:

    Second, I am a member of the workspace. So that doesn't explain it.

    Further, I can connect to the dataflow from the legacy connector, but not using the new PowerPlatform connector. The problem isn't that I can't connect to the dataflow at all, but that I can't connect to it using the new connector.