topic Re: PowerBI Report Builder and Oracle Connection Type - credentials not accepted in Developer

PowerBI Report Builder and Oracle Connection Type - credentials not accepted

Anonymous — Sat, 11 Apr 2020 00:14:28 GMT

Hello.

I've just downloaded and installed Power BI Report Builder version 15.0.1517.0.

I would like for my very first report to connect to an Oracle database. I am getting an invalid password error when using credentials that I know are correct. Here is my setup:

1. Create a new Datasource. Connection Type = 'Oracle Database'

2. built the connection string using the tool. I used a server name, user name, and password that I know are correct and that I know I can connect to from my computer.

3. test connection - I get ORA-01017 invalid username/password

4. Opened the 'Change Data Source' control and see these options with the Oracle connection type.

5. The Oracle DB I want to connect to is 11.2.0.3.

6. I have the 64-bit and 32-bit Oracle 12.2.0 client installed. I am not sure I have registered the ODP.NET drivers in GAC.

7. I noticed the note about the .NET Framework client not matching my Oracle version, and that the provider is deprecated. Is there way to get another data provider in there with something more current?

thanks!

Re: PowerBI Report Builder and Oracle Connection Type - credentials not accepted

millwardt — Sat, 11 Apr 2020 12:01:12 GMT

I'm having the exact same issue connecting to an Oracle 12.2.0.1 database

Re: PowerBI Report Builder and Oracle Connection Type - credentials not accepted

Watsky — Wed, 06 Jan 2021 16:51:35 GMT

@Anonymous @millwardt

I had the exact same issue you were facing. I clicked on Advanced at the Connection Properites window and noticed Integrated Security was set to True. I changed this to false and that allowed me to connect.

Hope this helps you both.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.