Couldn't find oracle database in connection type list

[MichaelSun]

When I want to create a data source connecting to Oracle database, I couldn't find Oracle database option in connection type list. Could anyone give any advice? Thanks a lot.

[sevenhills]

For SSRS or PBIRS, you need to install the drivers explicitly

Check these links for more info

https://www.oracle.com/a/otn/docs/database/connecting-ssrs-to-oracle-adb.pdf 

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?vie...

Once you have installed and have the configurations done, you can use it as simple as in the connection string. 

 

Hope this helps!

[jaweher899]

To connect to an Oracle database in Power BI Desktop, you can use the "ODBC" or "OLE DB" connection type, which are generic connection types that can be used to connect to a wide variety of data sources, including Oracle.

Here are the steps to connect to an Oracle database using ODBC or OLE DB in Power BI Desktop: