How to update oracle data source credentials for on-premises gateway ?

[srivp07]

Not able to update credentilas for Oracle SQL data source, accouht is getting locked. I am using  connection  on personal mode gateway and Standard mode gateway. credentials are geeting updated only on personal mode and not on satandard mode. Henceforth,Oracle DB account getting locked. Please help!

[v-kathullac]

Hi @srivp07  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @srivp07  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @srivp07  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[srivp07]

Hello Chaitanya,

I followed the troubleshooting steps you mentioed. First I tried to connect to oracle data source from desktop app.

Got account unlocked from DBA.

Cleared all permeissions.

Removed data source fro global source and closed desktop app.

Added new credentials in personal gateway and it accepted.

Restarted personal gateway

Opened dektop app, connected to oracle data source with new credentials and run the SQL query from the popped window.

All data appeared on dashboard with current date. Also I was able to refresh data. Then after few mins account got locked and data disappreed from dashboard with error unable to connect to source.

When I checked credentials, I could see it was switched back  to old credentials. Password was old one and not newly updated one.

I had creed ticket to Microsoft team and that time I was not able to connect to data source from desktop app itself and they redommanded to contact DBA or database team. However, my DBA says it is power BI issue whicj is locking account.

Could you please elaborate more on Properly configured TNSNAMES.ORA file.

please share screenshot or details how this file should be configured.

currently it is like as below. Do I need to fill out these details? Also I do not see any password or credentials  fields in those details.
<data source alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname or IP>)(PORT = <port>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <database service name>)
)
)

Thanks much for your consistant support!

[v-kathullac]

Hi @srivp07 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

I have given all the possbile debug steps to resolve your issue can try below as well.

1)Ensure only the 64-bit Oracle client is installed and check the Oracle client path using where tnsping in Command Prompt.

2)Test the TNS alias resolution with tnsping <TNS alias>.

3)Locate and open the tnsnames.ora file (e.g., C:\oracle\product\<version>\client_1\network\admin\tnsnames.ora).

4)Ensure the correct format in tnsnames.ora for the Oracle alias:
MYORACLEDATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname/IP>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <your_service_name>)
)
)
5)In Power BI Desktop, go to File → Options and settings → Data source settings and remove all existing Oracle-related data sources and credentials.

6)Open Credential Manager in Windows Control Panel and delete any saved Oracle or Power BI Gateway credentials.

7)In the On-premises data gateway app, remove any old Oracle data sources and add a new data source with the correct TNS alias and updated credentials.

8)Restart the On-premises data gateway after saving the new configuration.

9)In Power BI Desktop, choose Oracle Database as the source, enter the correct TNS alias, and provide the updated username/password for authentication.

10)In Power BI Service, go to Settings → Datasets → Data source credentials, update the credentials, and temporarily disable scheduled refresh until all configurations are verified.

Regards,

Chaithanya.

[srivp07]

Thank you Chaintanya for your sugesstions. Howerver,I have checked credentials manager for windows and did not find any oracel credentilas and cleared prermissions and removed all existing oracle connections from desktop app also cleared cached data data from file-> Options. and restarted personal gateway and it is still locking oracle account. I stopped Standard On-Premises Gateway service from server and satandand gateways is offline now. Still oracle account is getting locked in SQL developer. Did traceroute to hotname and it is showing Request timed out after 4 hops. 

Also  I have few questions regarding steps you recently mentioned.

3)Locate and open the tnsnames.ora file (e.g., C:\oracle\product\<version>\client_1\network\admin\tnsnames.ora):

Q. On my PC tnsnames.ora file is at 2 locations: 1. 1. 1.C:\Users\****username\ODAC122010Xcopy_x64\network\admin\sample location.

2.C:\Program Files\Oracle Client for Microsoft Tools\network\admin\sample

Q: Do I need to fill out those details in  tnsnames.ora file and if yes then which folder location file I need to fill out since I have file at 2 locations.

4)Ensure the correct format in tnsnames.ora for the Oracle alias:
MYORACLEDATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname/IP>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <your_service_name>)
)

Q.   2)Test the TNS alias resolution with tnsping <TNS alias>. 

Where I can find TNS alias?

Thanks much for your consistant support!

[v-kathullac · Accepted solution]

Hi @srivp07 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

can you check this below mentioned points.

1)Normally, Oracle uses the tnsnames.ora based on which Oracle Client the application is using.

2)If your SQL Developer is installed separately, it usually does not read these files. But if any Power BI / Gateway / ODBC connection uses Oracle Client, then it depends on which client path is referenced in the PATH Environment Variable.

3)Check your Environment Variable PATH and see if any of these paths (ODAC or Oracle Client for Microsoft Tools) is mentioned. Whichever client path is first in the PATH variable, that's the one the system will use.

Q2)
MYORACLEDATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_oracle_server_hostname_or_ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = your_service_name_from_DBA)
)
)
HOST = the Oracle server's hostname or IP
SERVICE_NAME = your Oracle Database's service name (like orcl.example.com or whatever your DBA provides).

3)Ask your DBA to check the Oracle sessions to find which machine/program is locking the account.

Regards,

Chaithanya.

[v-kathullac]

Hi @srivp07 , 

Acutually tried all the possibilities still you are facing the issue i dont where you are missing Can you please raise a Microsoft support ticket for further investigation so that they will connect with you and solve your issue.

You can create a Microsoft support ticket using the link below.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Regards,

Chaithanya.

[srivp07]

I created ticket to the Microsoft team and they asked me test if I can update credentials from desktop. I am unable to update credentials from desktop it is locking account. When I tried to clear permissions and updated credentials then it connected to Oracle data base, however when I refreshed the data, it locked oracle account again and credentials were not updated, I could see old password in data source settings. Please suggest! Thank you!

[v-kathullac]

Hi @srivp07 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

I have given all the possbile debug steps to resolve your issue can try below as well.

1) Clear all Power BI cached credentials via File - Options and settings - Data source settings - Global Permissions and remove all Oracle entries.

2) Open Credential Manager in Windows. Under both Windows Credentials and Generic Credentials, remove anything related to Oracle or Power BI.

3) Restart your PC to ensure all cached credentials are fully cleared.

4) Open Power BI Desktop, load your report, and when prompted, enter the correct Oracle username and password, choosing the "Database" authentication method (not Windows).

5) Avoid auto-refresh instead, perform a manual refresh first to verify successful connection.

6) Check for any scheduled refreshes, background previews, or other users that might be using outdated credentials.

7) If you are using Power BI Service, ensure you also update the credentials in the gateway settings.

8)If the issue persists, please contact your Oracle DB team to reset the account credentials and ensure the account is unlocked.

Regards,

Chaithanya.

[v-kathullac]

Hi @srivp07,

Thank you for reaching out to Microsoft Fabric Community Forum.

Here are the few troubleshooting steps to resolve your issue.

1. Check for other services (scripts, reports, apps) still using old password — they may cause account lock.
2. Ask your DBA to unlock the Oracle account and check login failure sources from Oracle logs.
3. Update credentials in Power BI Service:
4. Go to Manage Gateways → Select your data source.
5. Click "Edit Credentials", enter correct username/password.
6. Choose Basic Authentication (if applicable), then Save.
7. Ensure the Gateway machine has Correct version of Oracle client installed (32/64-bit matching the gateway).
8. Properly configured TNSNAMES.ORA file.
9. Network connectivity to Oracle server (test with tnsping).
10. Restart the Gateway service after updating credentials.
11. Ensure no scheduled refreshes are running with old credentials before you update password.

Regards,

Chaithanya.

[srivp07]

Thanks Chaitanya  for the troubleshooting steps, Unfortunately I deleted the data source from gateway connections and trying to add new one , also scheduled refresh option is disabled now.  Currently it is showing gateway configured incorrectly error cross sign in front of oracle connection , howerver when I try to add it in gateway it is locking the oracle account. I wonder if I deleted existing connection from gateway then why it is showing in data source connection list with Add to Gateway option? Also Data source credentials option is disabled. Please help! Thank you!

[v-kathullac]

Hi @srivp07 ,

It looks like you’re facing multiple issues with the Oracle data source and gateway setup. Here's a step-by-step guide to  resolve your issue

• Make sure the on-premises data gateway is running and up to date on the server.

• Open the gateway app and confirm it's showing as online.

• Oracle account may get locked due to incorrect credentials from earlier attempts.

• Too many failed login attempts can also lock the Oracle account.

• Reset the Oracle password and test it using SQL Developer.

• Avoid reusing the old password immediately, as Oracle might still lock it.

• Work with your DBA to unlock the Oracle account and monitor during setup.

• Go to Power BI Service  Manage Gateways and select your gateway.

• Click on "New Data Source" to add a new Oracle connection.

• Use the exact same Server Name, Port, and Database Name as your dataset.

• Enter the correct Oracle credentials when adding the data source.

• Save the new Oracle data source connection in the gateway.

• Go to Dataset Settings in Power BI Service.

• Under "Gateway connection", check if the new Oracle data source has a green checkmark.

• If you see "Add to Gateway", click it and map the dataset to the new connection.

• The old data source may still show up because the dataset is referencing it.

• Once the new gateway connection is successful and credentials are validated, the Scheduled Refresh option will be enabled again.

Regards,

Chaithanya.

[srivp07]

Hi Chaitanya,

Thanks a lot for providing resolution steps. I tried to follow above steps , DBA unlocked oracle account. I tested connection from SQL Delveloper tool and connection was successful. After this I confirmed the Gateway is online and  I tried to add new connection and it locked the account again. Please advise!

Thank you!

[GilbertQ]

Hi @srivp07 

Please find the details below when you can go into the manage connections gateways section and then find your data source and from there you can then right click and select settings where you can then update the password.

[srivp07]

Thanks GilbertQ for your response, howerver when I updated password it is locking my oracle account immidiateley. I tested the connection in SQL developer before updating in on premises  Gateway and I logged in successfully and failing to upddate in gateway. Also it shows , gateway configured incorrectly error message. Please help!