The following is a general tutorial for connecting from Power BI Desktop (Optimized for Report Server) to OBIEE using ODBC with BI Connector Desktop Edition.
Pre-requisites
- Microsoft Power BI Desktop (Optimized for Report Server).
- Install BI Connector Desktop Edition for Microsoft Power BI on your PC. (Refer to Step-by-Step Installation Guide for BI Connector Desktop Edition for Microsoft PowerBI)
Connecting from Power BI Desktop (Optimized for Report Server) to OBIEE Reports
Launch PowerBI Desktop (Optimized for Report Server)
Launch Power BI Desktop (Optimized for Report Server). Select 'Get Data' option.
Select ODBC
In the Get Data dialog, select ODBC and click connect.
Enter DSN Information
- Choose the DSN connecting to OBIEE Reports that you configured after installing BI Connector.
- Click Ok button.
- Enter the credentials and click Connect.
Now you can create the reports required.
Connect to the Database
Click on the Database name to connect to the required database.
Select the report
- On Successful Connection, a Report will be displayed if you provide a path of a particular report or a list of Reports will be displayed if you provide a path of the folder. You can Select the Report from the list also.
- The list of Reports will be displayed just like a Table. Select a report and click on load.
Select the fields to visualize
Drag and drop or select one or more fields to the join area.
Choosing a different visualization
Choose the desired visualization and you have now successfully created your first Power BI Visualization for OBIEE reports data.
Saving the Report in Power BI Report Server
- After creating the report, navigate to File and choose Save As, and select Power BI Report Server.
- Enter the URL of the Report Server, and click Save.
- The report shows up in your Report Server.
Now that we have seen how to connect Power BI Desktop (Optimized for Report Server) to OBIEE Reports, you may also want to see how to configure scheduled refresh for the reports in the Power BI Report Server.