Power Automate - Oracle Connector

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Am using Power Automate to fetch some data from Oracle database using Oracle Connector available.

But the strange issue is that it is not returning the entire list of tables from the database.

Its shows the first X set of tables in alphabetical order.

I find an option to enter the custom table name which I tried. But it says the table does not exist.

I fetched the data from the same table using Power BI and it works successfully. Am able to get all the data.

The same gateway is used for both Power Automate and Power BI for connecting to Oracle Database. So its definitely not the issue with the gateway.

Am stuck with this issue, since there is no way forward.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

How many tables does the oracle database have?

I'm afraid that there is any limit on the count of the tables in the oracle database, so the connector could only display part of the tables.

And we couldn't manually enter the table name for identify the table in the oracle connector.

Best regards,

Alice

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Alice,

Appreciate your response.

The oracle database does has more than 300 tables.

So what I understand is that there there is a threshold limit for the number of tables in the oracle database.

Can you let me know what is the threshold limit?

Also please confirm me if this limit is applicable for Power Automate only. Because i don't find this issue in PowerApps and am able to connect to this particular table in PowerApps.

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Sorry for there is no any documentation telling about it so I couldn't share the details.

Best Regards,

Alice

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

Was this reply helpful? Yes No