Dataflows with Oracle source - source does not appear in 'data source credentials'

[JoshT]

I have a dataflow with a few queries that connect to an Oracle source. It was working fine for a while but after a recent edit I was getting in a loop with the message 'we could not evaluate this query due to invalid or missing credentials', so I selected the credentials from the gateway (which are working), but just got the same message again.

I try to create a new connection and I get an interface with no options and no way to continue:

Checking the settings page, the data source credentials expandable is greyed out:

This is not a problem with the gateway or client software - datasets with oracle sources can still be configured and refreshed successfully. Has anyone had this issue? At the moment there don't appear to be any ways around it as I can't even create a new dataflow without hitting this wall.

[v-cazheng-msft]

Hi @JoshT,

Could you please check in the Connection section of the dataflow Settings page whether the Oracle data source used by the dataflow has mapped to the data source registered to the Gateway?

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[JoshT]

Hi Caiyun,

This is what I said here, that the connections part is greyed out and the oracle connections don't even register. I have also added a SQL Server connection to the dataflow, at which point the data source credentials section can be expanded, and only the SQL Server connection appears. This is definitely a bug where Oracle connections are not being recognised and as such it's impossible to map credentials to a gateway connection through any interface, as explained above.