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 a...
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!
v-diye-msft
Community Support
Community SupportHi 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
Microsoft Employee
Microsoft EmployeeDo I need a gateway to refresh on the cloud? Even if the Oracle db is cloud?