Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jsangerman
Helper I
Helper I

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, someone within my company recently sent me a pbix file that uses the legacy connector, and I can connect using that without problem. However, I want to use the dataflow that person created in Excel, which only has the new Power Platform connector. In Excel using the Power Platform connector, I can't connect to the dataflow using the same workspace ID and dataflow ID nor is it visible in the selection list.

 

In summary, using the legacy connector I can see and connect to a dataflow owned by another user, but I can't see nor connect to it using the new connector. What's going on?

3 REPLIES 3
jsangerman
Helper I
Helper I

Anyone know why I would be able to connect to a dataflow dataflow using the legacy Power BI connector but not the new Power Platform Dataflows connector?

v-jingzhang
Community Support
Community Support

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.

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:

jsangerman_0-1677005085640.png

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors