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


InformationGrid.Contents( server as text ) as table


Retrieves information from authorised BI services available on the given server


Returns a Navigation Table listing the available Information Grid BI services

// Output: ( Navigation table listing available BI services )
InformationGrid.Contents( "", false )

Returns information from a specific named Information Grid BI service using HTTP

// Output: ( Data retrieved for the named BI service )
InformationGrid.Contents( "", true ){[Service="service-name"]}[Data]
BI Gorilla Blog

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.