Forum Discussion
Connect power bi to oracle autonomous Database securely
1 - What is the best way to connect power bi to the Oracle Autonomous Database securely?
2- Do we require an Oracle API for this to be secure?
Hi powerbiuserone ,
You can refer to the step-by-step tutorial guide to learn how to connect Oracle Autonomous Database:
https://www.oracle.com/a/ocom/docs/database/microsoft-powerbi-connection-adw.pdf
There are two connection modes of Oracle Autonomous Database, Direct Query and Import.
Direct Query is more secure than Import mode because it does not import data into Power BI Desktop, it is a direct connection to the data source. For more information, you can refer to:
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi powerbiuserone ,
You can refer to the step-by-step tutorial guide to learn how to connect Oracle Autonomous Database:
https://www.oracle.com/a/ocom/docs/database/microsoft-powerbi-connection-adw.pdf
There are two connection modes of Oracle Autonomous Database, Direct Query and Import.
Direct Query is more secure than Import mode because it does not import data into Power BI Desktop, it is a direct connection to the data source. For more information, you can refer to:
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.