question

ShivaniBhandigare-7584 avatar image
0 Votes"
ShivaniBhandigare-7584 asked Zoehui-MSFT edited

Not able to connect to Oracle Database in Microsoft Flow

Hi,

I am trying to connect to oracle database in microsoft flow but I am not able to connect. I have installed oracle client as well. I have two queries there:

  1. I am able make oracle database connection in Power BI. Data has been loaded successfully. But same thing when I tries in MS flow , I am getting following error.

142426-image.png










  1. I don't have Premium license of Power Automate. Is this issue coming because of license or any other reason

power-query-not-supported
image.png (55.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

It sounds like the Oracle client software/driver installed on your gateway machine needs to be upgraded.

Also, Power Query is no longer supported here on Q&A. Please post on https://aka.ms/PQCommunity in the future.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.