- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous
Your name should in the list like below.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
You can add users to data source under the gateway:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am added as a user on the data source and still receive those errors.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
Because you are not the Administrator of the Gateway.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-07-2024 12:48 PM | |||
12-28-2024 06:01 AM | |||
Anonymous
| 04-04-2024 07:36 PM | ||
01-28-2025 02:14 PM | |||
10-08-2024 01:57 AM |
User | Count |
---|---|
55 | |
54 | |
49 | |
13 | |
13 |