Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.
With Microsoft Power Query for Excel, you can easily connect to an SAP BusinessObjects BI Universe to explore and analyze data across your enterprise. You can also share your insights to the Power BI Data Catalog so that others can benefit from your subject area expertise and insights.
To connect to an SAP BusinessObjects BI Universe
In the POWER QUERY ribbon, selectFrom Other Sources > SAP BusinessObjects BI Universe.
In the From SAP BusinessObjects BI Universe dialog, enter the URL for the SAP BusinessObjects BI 4.1 SP2 or higher system you’d like to connect to as http://<host>:<port>/biprws.
The default port of the service is 6405.
Enter your credentials for the service. Use the options in the dialog to view all possible credential types. Choose the credential type supported by your service and enter your credentials. Once connected, you may see some progress information in the dialog.