Fabric Dataflow gen 2 can't connect to Oracle database

[fefecavieres]

Hello!,

I'm new using MsFabric. I've trying to connect to an Oracle database with a Dataflow Gen 2 but I got and error message as is showed in the image: No ODAC driver is found on the system.

This doesn't happen when I use PowerBi Desktop.

Is there something I'm doing wrong or something I could do in order to connect with this DB?

[fefecavieres]

thank you!

[miguel · Accepted solution]

Hi,

You can read more about this connector from the documentation link below:

Power Query Oracle database connector - Power Query | Microsoft Learn

Based on the error message shown, I'd highly recommend making sure that the computer where your Data Gateway is hosted has the ODAC driver installed.