Forum Discussion
connect power bi to oracle cloud database
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
5 Replies
- v-diye-msft
Community Support
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
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)))
hiimhpMicrosoft Employee
Do I need a gateway to refresh on the cloud? Even if the Oracle db is cloud?
