SapBusinessObjects.Universes
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Connects to the SAP BusinessObjects BI Universe at the specified URL and returns the set of available universes.
SapBusinessObjects.Universes(url as text) as table
| Argument | Description |
|---|---|
| url | The URL of the SAP BusinessObjects BI Universe to connect to. |
The function returns a top-level table of two rows. The row with Id = “Universes” contains a nested table of all of the universes available at the URL. The row with Id = “DisplayFolders” contains a nested tree of tables representing the display folder hierarchy of the available universes.
The table of universes provides a stable path to access a particular universe by its ID.
The nested tree of display folder tables provides a user-friendly way to organize and navigate to universes and is not guaranteed to remain stable.
SapBusinessObjects.Universes("http://sap.example.com:6405/biprws")