InformationGrid.Contents is a Power Query M function that retrieves information from authorised BI services available on a given server.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
InformationGrid.Contents( server as text ) as tableDescription
Retrieves information from authorised BI services available on the given server
Examples
Returns a Navigation Table listing the available Information Grid BI services
// Output: ( Navigation table listing available BI services )
InformationGrid.Contents( "192.168.1.123", false )Returns information from a specific named Information Grid BI service using HTTP
// Output: ( Data retrieved for the named BI service )
InformationGrid.Contents( "igserver.somedomain.com", true ){[Service="service-name"]}[Data]