Zucchetti.Contents

Updated on

Zucchetti.Contents is a Power Query M function that returns contents of VisualQueries (vqr), reports or functions published by the Zucchetti HR software.

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

Syntax

Zucchetti.Contents(
   Url as text,
   Environment as text,
) as table

Description

Returns contents of VisualQueries (vqr), reports or functions published by the Zucchetti HR software

Examples

Request for employees list

// Output:     Table containing employee list
    Zucchetti.Contents( "https://myurl/HRPortal/", "001" ),
    ERM = Origine{[idproced="ERM"]}[Data],
    ERM_query_pbi_employee = ERM{[id="ERM_query_pbi_employee"]}[Data]
BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot