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


   url as text,
   optional table as nullable text,
   optional columns as any,
   optional filter as nullable text,
   optional orderBy as any,
) as table


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.


Selects text and date columns

TeamDesk.Select( "", "Meeting", { "Starter", "Start Date", "Participants" } )

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

Other functions related to TeamDesk.Select are:

BI Gorilla Youtube Channel

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