Connect to SAP BusinessObjects BI Universes (Power Query)

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

  1. In the POWER QUERY ribbon, selectFrom Other Sources > SAP BusinessObjects BI Universe.

  2. 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.

  3. 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.

Power Query Data Sources

See Also

Connect to SAP BusinessObjects BI Universes with Power Query

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×