Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Oracle Direct Query - Couldn't Connect

Hi Guys,

 

I have to fetch the Data from oracle Data base(Direct Query ), so installed ODAC in PBI front end server and Connected to Oracle its working fine in Desktop but not is Power Bi report server portal.

 

I Have connected by using below string. please assist me to connect from PBIRS

 

IP:Port/service Name

 

Thanks,

Rav

 

1 ACCEPTED SOLUTION
sevenhills
Super User
Super User

Assume, you have installed the Oracle drivers (if not, a bunch of to do list - https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view...

 

  • Install the software "Oracle Client" / Drivers
  • Configuration for the database (tnsnames.ora). 
  • Ping the oracle server from PBIRS server
  • Use the username and password to access the database.
  • Optional: RDP to PBIRS and use the Power BI Desktop of PBIRS version and try to make connection

 

Typical connection string in the data source

DATA SOURCE=<Data source name>

 

Optional: You can also try the below in the connection string:

Data Source= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=<HOSTNAME>) (PORT=1521))
(CONNECT_DATA= (SERVICE_NAME=<SERVICENAME>) ) )

 

 

View solution in original post

2 REPLIES 2
sevenhills
Super User
Super User

Assume, you have installed the Oracle drivers (if not, a bunch of to do list - https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view...

 

  • Install the software "Oracle Client" / Drivers
  • Configuration for the database (tnsnames.ora). 
  • Ping the oracle server from PBIRS server
  • Use the username and password to access the database.
  • Optional: RDP to PBIRS and use the Power BI Desktop of PBIRS version and try to make connection

 

Typical connection string in the data source

DATA SOURCE=<Data source name>

 

Optional: You can also try the below in the connection string:

Data Source= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=<HOSTNAME>) (PORT=1521))
(CONNECT_DATA= (SERVICE_NAME=<SERVICENAME>) ) )

 

 

Anonymous
Not applicable

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.