connect power bi to oracle cloud database

[Anonymous]

Hi Everyone,

I got a requirement for my client where I need to build reports by connecting power bi to oracle database cloud and have to implement data level security. 

is there an possibility to achieve this requirement?

Thanks In advance

regards,

Rakesh

[v-diye-msft]

Hi @Anonymous ,

You can connecting oracle database referring this document:

https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database

Then implement the RLS:(You can now configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery)

https://docs.microsoft.com/en-us/power-bi/desktop-rls

[hiimhp]

Do I need a gateway to refresh on the cloud? Even if the Oracle db is cloud?

[Anonymous]

Hi,

 Thank you so much for the response.

I am able to connect to the oracle database which is residing in my local machine and on premise server too. Actually, I want to connect the cloud oracledata base which is sitting in the oracle server. Do I need to follow the same process to connect to the Oracle cloud?

However, I tried to connect the oracle cloud database by following the below steps.

https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database

Server entry box is not allowing me to put more than 128 char as my server name is exceeding 128 char string limit 

I used below format for the server name

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LOACAHOST)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=Servicename)))

[Salama]

Dear could you please more details about how to connect to oracle cloud ? 

thanks in advance 

[Anonymous · Accepted solution]

I am able to conect to the cloud database bt creating alias name for the entire string and passsed it in the service name box. 

ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LOACAHOST)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=Servicename)))

Thanks!