topic Re: Need the Creator role on the Data Gateway to use a Data Source in a Data Pipeline ? in Pipelines

Need the Creator role on the Data Gateway to use a Data Source in a Data Pipeline ?

vivien57 — Wed, 19 Jun 2024 12:03:45 GMT

Hello,

I have an Oracle data source that is defined at a Data Gateway level. I have the user role on this data source.

When I try to configure a data copy in Data Pipeline, with this connection I get the following error :

To solve the problem, I need to be given the "Creator" role on the Data Gateway.

Is this normal?

Because I don't want to create a Data Source, but to create a connection to a Data Source previously created by another person, on which I have the "User" right.

Thank you in advance for your feedback,

Have a nice day,

Vivien

Re: Need the Creator role on the Data Gateway to use a Data Source in a Data Pipeline ?

Anonymous — Thu, 20 Jun 2024 11:23:11 GMT

Hi vivien57 ,

Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

Re: Need the Creator role on the Data Gateway to use a Data Source in a Data Pipeline ?

Anonymous — Fri, 21 Jun 2024 10:07:25 GMT

Hi vivien57 ,

Thanks for using Fabric Community.

As it to looks like a permission issue, you need to have enough permission in order to do a connection.

After providing Creator role it got the right permission to proceed. Incase if you have concern in providing any role and want to have detail answer, please open a support ticket.

Re: Need the Creator role on the Data Gateway to use a Data Source in a Data Pipeline ?

Anonymous — Mon, 24 Jun 2024 07:35:08 GMT

Hi vivien57 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Re: Need the Creator role on the Data Gateway to use a Data Source in a Data Pipeline ?

vivien57 — Tue, 25 Jun 2024 07:56:08 GMT

Hello,

My question is whether the role creator is necessary for Data Pipelines (whereas it isn't for DataFLows). I can't find this information in the official Microsoft documentation.

Have a nice day,
Vivien

Re: Need the Creator role on the Data Gateway to use a Data Source in a Data Pipeline ?

Anonymous — Tue, 25 Jun 2024 09:49:44 GMT

Hi vivien57 ,

The best course of action is to open a support ticket and have our support team take a closer look at it to answer:Link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

Re: Need the Creator role on the Data Gateway to use a Data Source in a Data Pipeline ?

vivien57 — Wed, 03 Jul 2024 06:18:04 GMT

Hello,

In the official documentation here, it is written :

https://learn.microsoft.com/en-us/data-integration/gateway/manage-security-roles

User: A user is allowed to use the connection (data source) in Power BI reports and Power BI dataflows. A user isn't allowed to see or update credentials.

Nothing is specified for Data Pipelines that come from the Fabric world, not the Power BI world.

So, as I understand it, the User role on a Data Gateway data source is not enough to use a connection.
You need the "Creator" role at Gateway level.

If this is the case, just update the documentation.

Thank in advance,

Vivien