Dataflows require gateway admin?

[Anonymous]

Hi,

One of the users in our organization is trying to create dataflows basing on Oracle Database and he is unable to create it without gateway admin role. He is assigned as user to the specific gateway connection though. In Microsoft documentation it states that it should be enough:

"To create a dataflow using a gateway, the user must be the Enterprise Gateway’s administrator, or the administrator must have shared the datasource they are planning to use with the user."

Even if the users is assigned as user to specific gateway connection, we still see the error:

Did anyone came across similar issue?

BR,

Karol

[v-lionel-msft]

Hi @Anonymous ,

• Dataflows are only supported using enterprise gateways. Personal gateways will not be available for selection in the drop down lists and settings screens.
• On-premises data sources configured with the Use SSO via Kerberos for DirectQuery And Import queries option are not supported in dataflows.

Do your data sources and gateways meet the above limitations?

Best regards,
Lionel Chen

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

[Anonymous]

Hi Lionel,

We are using Enterprise Gateway and there is no SSO set up for this source.

BR,

Karol

[mahimabedi]

Yes, you do not need to be an admin of the gateway, just a user for the datasource in the gateway. It used to be the case that you needed to be an admin, but no longer true.

Have seen this issue before, opened a bug for this a couple of times. In fact have one open open right now.

PS: Please mark this post as a "solution"  if this helps solving the issue and/or hit the "thumbs-up" button if you found this insighful. Thanks.