web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataflow in powerapps ...
Power Apps
Unanswered

Dataflow in powerapps not connecting to oracle

(0) ShareShare
ReportReport
Posted on by 145

Hi I am trying to set up a dataflow for our dynamics entities to connect to oracle db.  I supplied the server info in the following format:

 

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = xxxx))(CONNECT_DATA =(SERVICE_NAME=nnnn.nnn.org))).  I have chosen the on-prem data gateway that was provided to us and using basic authentication supply username and password.  I am getting "An exception occurred: Oracle: ORA-12170: TNS:Connect timeout occurred (Session ID: 97672db7-6a93-4590-a093-bb8e5a67b891).  

 

I have used the same info above to connect power bi to the same database and it has worked.  Appreciate the help. Thanks. 

 

I have the same question (0)
  • Joel CustomerEffective Profile Picture
    3,224 on at

    Did you install on premise data gateway for power apps? It can't use the same one as power bi

     

    The error you posted is a general connectivity issue.

     

    Please follow the steps in this post to connect to your oracle database https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps/

     

    Also note that it is finicky about version of database and data tools.

    Supported versions: Oracle 9 and later, Oracle client software 8.1.7 and later.

     

    @UC3378 if this answers your question please mark it a solution

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 802 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 273

Last 30 days Overall leaderboard