TeamDesk.Select

Updated on

TeamDesk.Select is a Power Query M function that retrieves the data from selected columns in a provided table. It also allows for the application of an additional filter for results and changes in the order in which records are retrieved.

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

Syntax

TeamDesk.Select(
   url as text,
   optional table as nullable text,
   optional columns as any,
   optional filter as nullable text,
   optional orderBy as any,
) as table

Description

Retrieves the data from select columns in provided table. You can also apply an additional filter for results as well as change the order in which records are retrieved.

Examples

Selects text and date columns

TeamDesk.Select( "https://www.teamdesk.net/secure/db/57692", "Meeting", { "Starter", "Start Date", "Participants" } )

 /* Output: 
#table( 
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date( 2018, 10, 12 ), 10 },
// ...
}
 )
 */ 

Other functions related to TeamDesk.Select are:

Contribute » | Contributors: Rick de Groot