Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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!
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
Do I need a gateway to refresh on the cloud? Even if the Oracle db is cloud?
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)))
Dear could you please more details about how to connect to oracle cloud ?
thanks in advance
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.