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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
cheryl-lee33
Helper I
Helper I

How can I share a dataflows with Power BI pro users?

Hi,

 

I have recently started developing PBI dataflows.  During the licensing conversation, I was told that pro license holders can use dataflows, but they can't develop or change anything.  Yet, I just tried to test whether the pro users can access the dataflows stored on the premium workspace, but they can only access the workspace but not the dataflows.  

Can someone please share with me how you use dataflows to standardise the data transformation?

 

Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @cheryl-lee33 ,

There are some limitations for Power BI Pro:

vbinbinyumsft_0-1699251447186.png

For more details, you can read related document: What licenses do you need to use dataflows - Power Query | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

Hi @cheryl-lee33 ,

There are some limitations for Power BI Pro:

vbinbinyumsft_0-1699251447186.png

For more details, you can read related document: What licenses do you need to use dataflows - Power Query | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Brunner_BI
Super User
Super User

Only one person can edit/own the Dataflow. So you need to "take it over" if you want to change stuff around there.

Generally, you can only give permissions on the workspace I think.

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

Hi,

Thank you for your input.  

In the future, we will have someone else to edit the dataflows too.  For now, I just want to be able to allow pro users to use the tables output by dataflows.  Is there a way for that to happen?

Thanks!

Is it Premium Per User or a Premium Capacity?

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

Hi, 

I now understand what you were asking.  We have a premium per user workspace.

The users have pro licenses.  The dataflows are sitting on premium workspace.  The users can see Report/Dataset but not dataflows.

If they can see reports and datasets in a workspace but cannot see a dataflow in the same workspace I would think that they might only have viewer rights + build on the dataset potentially?

Maybe someone else has another idea but this is the only thing I can think of for that scenario.

If you have contributor or member or higher you should be able to see all artifacts in that workspace.

You cannot give permissions on a Dataflow on its own, it happens through the workspace rights.

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

We did try contributor and it still did not work.  At the moment, I think it may be due to the limitation of "calculated table" or "linked table"?

If that's the case, it is so annoying that licenses are too confusing.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors