Emigo.Contents

Emigo.Contents is a Power Query M function that sets parameters for OData feed data source calls, which can limit non-function calls by, for example, the period.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Emigo.Contents(
   optional DataRestrictionType as nullable text,
   optional DataRestrictionValue as nullable text,
   optional DataRestrictionMode as nullable text,
   optional AuthorizationMode as nullable text,
) as table

Description

The purpose of the method is to set parameters for odata feed data source calls, thus the non-function calls may be limited by, for example, the period

Examples

The purpose of the function is set the feed call parametrs

// Output: "#Filtered Rows"( {"IDDZiennik", "DataNumerycznie"}, {{132806, 20190220}, {132803, 20190220}} )
let
    Source = Emigo.Contents( "DAYS", "3", "exact", null ),
    emigoList = Source{[Key="emigoList"]}[Data],
    Dziennik_table = emigoList{[Name="Dziennik",Signature="table"]}[Data],
    #"Removed Columns" = Table.RemoveColumns( Dziennik_table,{"CzasWykonywaniaSekundy", "CzyCzasUKlienta", "CzyCzasDojazdu", "CzyZdjecia", "Odrzucona", "Obligatoryjna", "Wykonana", "DataCzasRozpoczecia", "DataGodzina", "Data", "Hierarchia", "IDCzynnosciTypy", "IDDziennikGrup", "IDGrupaDocelowa", "IDLogin", "IDKlient", "IdPrzOdm", "IDZadania", "IDTypZadania", "IDTME", "SekundyMiedzyCzynnosciami", "IloscZdjec", "OkresWykonywaniaSekundy", "CzyZadanieWykonane", "AnulowaneNaTME", "OdlegloscKlientKM", "IDKatZad"} ),
    #"Filtered Rows" = Table.SelectRows( #"Removed Columns", each true )
in
    #"Filtered Rows"

Related functions

Other functions related to Emigo.Contents are:

• Emigo.GetExtractFunction
• EmigoDataSourceConnector.GetExtractFunction

Contribute » | Contributors: Rick de Groot