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.
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?
Solved! Go to Solution.
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.
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.
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.