Following is a general tutorial for connecting from Microsoft Excel to OBIEE Reports using BI Connector Desktop Edition.
Pre-requisites
- Microsoft Excel 64-bit.
- BI Connector Desktop Edition for Microsoft PowerBI. (Step-by-Step Installation Guide for BI Connector Desktop Edition for Microsoft PowerBI)
Connecting from Microsoft Excel to OBIEE Reports
Launch Microsoft Excel
Launch Microsoft Excel from your Windows machine.
Navigate to the Data tab on the top menu. Click on Get Data -> From Other Sources -> From ODBC.
The Data Source selection box pops up, choose the Report DSN from the list, which you want to work with, and click OK.
Enter Credentials
Under the Database section, enter the OBIEE User name and the Password. Click Connect.
Connect to the Database and Select the Report
Click on the Database name to connect to the required database.
- 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.
Now your OBIEE Report data is extracted to Excel, as shown in the screenshot below, and ready for analysis.
If you have any questions or issues creating a report, contact us at [email protected] or file a ticket at our support portal. We are just a click away.