cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LohithaSannathi
Helper III
Helper III

Unable to create APP thru oracle table.

 

Hi 

 

I have connected to Gateway

I have connected to our oracle Database successfully.  I am trying to fetch the data from oracle tables

I am able to see some of the tables , But I don't see all the tables here. May I  know the reason.

If I try to search table name  in Custom table column, it gives me error.

 

Please look at the attached error's

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @LohithaSannathi ,

Could you please share a bit more about your scenario?

Do you mean that it could not list all Tables when you create a connection to your Oracle server from your app?

 

Please check if you have typed a proper custom table name when you choose the Table to create connection. Also please check if the all tables that you mentioned belong to same database.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-xida-msft 

 

Could you please share a bit more about your scenario?

 

I am trying to create APP using Oracle Database Connector, When it populates all the tables , I don't see the table which I wanted to select. Please refer the attached screen shot.

 

Do you mean that it could not list all Tables when you create a connection to your Oracle server from your app?

 

yes

 

Please check if you have typed a proper custom table name when you choose the Table to create connection. Also please check if the all tables that you mentioned belong to same database.

 

yes , I tried to enter the table name in Custom table name but it gives me the error, Please refer the screen shot.

Yes they belong to same database

 

I have also seen in the below link there is limit for oracle connector for 150 tables only. Is this True??

 

Oracle Connector table limit 

 

 

Thanks

Lohitha

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,348)