cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frano72 Frequent Visitor
Frequent Visitor

sharing dataflows - only via member/contributor permission ?

Hi, I've been following the best practice guidance of separating ingestion from transformation for dataflows.

 

So i'm ready to share the dataflow to business users and keep with the "data reuse" theme of dataflows.

 

Do you think i coudl find any guidance on how to actually do this ?

 

This article shows how to connect to it from Desktop but doesn't cover the precedent step of how you were provisioned access.

https://docs.microsoft.com/en-us/power-bi/desktop-connect-dataflows

 

From my testing, it seems you need to provide people Contributor/Member/Admin to the workspace with the dataflow.  If you choose the lowest permission Contributor - then they can't edit the dataflow BUT they can take over ownership and change the scheduling !  Not Good.

 

I just want people to be able to connect to the dataflow.

 

Have I missed anything ?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
nickyvv Member
Member

Re: sharing dataflows - only via member/contributor permission ?

To access a dataflow you indeed need at least Contributor rights to the workspace.

I just tested this: With the Viewer role you do have access to the dataflow in Power BI Desktop, but you can't see the dataflow in the workspace.

 

In my opinion you can't edit a dataflow unless you created it yourself. That has to do with the access to the Data Lake folders that have been created:

image.png

 

Did this help you or did I answer your question?
Then please give kudos or mark my post as a solution!
My blog: nickyvv.com

View solution in original post

2 REPLIES 2
Highlighted
nickyvv Member
Member

Re: sharing dataflows - only via member/contributor permission ?

To access a dataflow you indeed need at least Contributor rights to the workspace.

I just tested this: With the Viewer role you do have access to the dataflow in Power BI Desktop, but you can't see the dataflow in the workspace.

 

In my opinion you can't edit a dataflow unless you created it yourself. That has to do with the access to the Data Lake folders that have been created:

image.png

 

Did this help you or did I answer your question?
Then please give kudos or mark my post as a solution!
My blog: nickyvv.com

View solution in original post

frano72 Frequent Visitor
Frequent Visitor

Re: sharing dataflows - only via member/contributor permission ?

Thanks Nicky !

 

Not sure what i did wrong in my initial testing, but did it again and it was as you say.

 

Viewer gives them rights to connect to dataflows from Power BI Desktop.

 

Perfect - exactly what I wanted cleared up.

 

I still think its a bit strange that I couldn't find any MS arcticles or guidance that specifically covers this pont of how to provide access to dataflows !  Maybe it was meant to be really obvious and no guidance was needed !

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)