Power BI (Windows only)
- Last Updated: November 28, 2023
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
After you have configured your data source, you can use the driver to access your data with Power BI. Power BI is a business intelligence software program that allows you to easily create reports and visualized representations of your data. By using the driver with Power BI, you can improve performance when retrieving data while leveraging the driver's relational mapping tools.
To use the driver to access data with Power BI:
- Open the Power BI desktop application.
- From the Get data menu, select More.
- The Get Data window appears. Select Other > ODBC; then, click Connect.
- The From ODBC dialog appears. Select your data source from the Data source name (DSN) drop-down list; then, click OK. To learn how to create a data source, see "Installing and setting up the driver (Windows)".
- Enter authentication information when prompted. Once connected, the Navigator window displays schema and table information.
- Select and load tables. Then, prepare your Power BI dashboard as desired.
You have successfully accessed your data and are now ready to create reports with Power BI. For more information, refer to the Power BI product documentation at Power BI documentation.