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
Anonymous
Not applicable

Permissions Issues With Creating Dataflows

I am running into several permissions issues with creating DataFlows and I'm not sure what the cause is. To start with some background, I know that DataFlows are enabled in the tenant settings (I verified with our PowerBI Admin that DataFlows are enabled for the entire org and he is able to create them) and that I am listed as a user on the on-premises data gateway. However, if I attempt to create a dataflow from our SQL Server Database I receive the following errors with the different types of Connection Credentials:

1. Windows - Only admins of an on-premise data gateway can create connections. To use this connection, switch to an on-premise data gateway that you are an admin of, or ask your on-premise data gateway admin to add you as a user of this connection. (Session ID: 1f011849-a015-488c-88d8-1809882a68a5)
2. Basic - Only admins of an on-premise data gateway can create connections. To use this connection, switch to an on-premise data gateway that you are an admin of, or ask your on-premise data gateway admin to add you as a user of this connection. (Session ID: 1f011849-a015-488c-88d8-1809882a68a5)
3. Microsoft - Unable to create an OAuth connection. Reason: "Only admins of an on-premise data gateway can create connections. To use this connection, switch to an on-premise data gateway that you are an admin of, or ask your on-premise data gateway admin to add you as a user of this connection. (Session ID: 1f011849-a015-488c-88d8-1809882a68a5)"


Any suggestions or help are greatly appreciated!

2 ACCEPTED SOLUTIONS

Hi @Anonymous ,

 

You must miss something. Did you login the gateway by the admin account in your server which holds sql server? Based on my test, after i add users to the data source under gateway. I can use the user to create dataflow in power bi .

Capture.PNG

 

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

 

Best Regards,

Dedmon Dai

View solution in original post

nickyvv
Most Valuable Professional
Most Valuable Professional

@Anonymous @v-deddai1-msft @aj1973 

For awareness, you don't need to be an admin of the (whole) gateway to create a dataflow.

You just need to be added to the specific connection you want to use, which you are as you mentioned @Anonymous.

But be aware, that Power Query (Online), and thus dataflows, are case sensitive. So you'll have to provide the correct casing (so the same as in the gateway), of the server and database for the connection to show up in the dataflow.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


View solution in original post

9 REPLIES 9
v-deddai1-msft
Community Support
Community Support

Hi @Anonymous ,

 

As mentioned by nickyvv, you need to provide server name  in the same format with credential in gateway.(All ip address or all server name)

 

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

 

Best Regards,

Dedmon Dai

aj1973
Community Champion
Community Champion

Hi @Anonymous 

Your name should in the list like below.

aj1973_0-1611625977874.png

 

Ask the administrator to the Gateway to add you

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

Is there any way for me to create a Data Flow without being an Admin? I thought they added the ability for users of a gateway to make data flows for gateways of which they're not an admin as per this Feature Summary Post:

https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-september-2019-feature-summary/

Hi @Anonymous , 

 

You can add users to data source under the gateway:

 

Capture.PNG

 

For more details, please refer to https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#add-users-to-a-data-source

 

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

 

Best Regards,

Dedmon Dai

Anonymous
Not applicable

I am added as a user on the data source and still receive those errors. 

aj1973
Community Champion
Community Champion

@Anonymous 

Because you are not the Administrator of the Gateway.

aj1973_0-1612222344643.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

Shouldn't I be able to create a dataflow as a non-admin though?

This feature summary says "Prior to this update, users would need to be an admin of the gateway before they could create a dataflow against the respective data source."

 

https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-september-2019-feature-summary/

Hi @Anonymous ,

 

You must miss something. Did you login the gateway by the admin account in your server which holds sql server? Based on my test, after i add users to the data source under gateway. I can use the user to create dataflow in power bi .

Capture.PNG

 

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

 

Best Regards,

Dedmon Dai

nickyvv
Most Valuable Professional
Most Valuable Professional

@Anonymous @v-deddai1-msft @aj1973 

For awareness, you don't need to be an admin of the (whole) gateway to create a dataflow.

You just need to be added to the specific connection you want to use, which you are as you mentioned @Anonymous.

But be aware, that Power Query (Online), and thus dataflows, are case sensitive. So you'll have to provide the correct casing (so the same as in the gateway), of the server and database for the connection to show up in the dataflow.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


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