InformationGrid.Contents

Updated on

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 table

Description

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]

Contribute » | Contributors: Rick de Groot