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
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

@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

@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
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.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

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.

Top Solution Authors
Top Kudoed Authors