Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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

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 ...
Dataflow
Need Help
  • v-kathullac's avatar
    v-kathullac
    1 year ago

    Hi Anonymous ,

    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's avatar
v-kathullac
Community Support
1 year ago

Hi Anonymous , 

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.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
    v-kathullac
    Community Support
    1 year ago

    Hi Anonymous ,

    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.