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 },
// ...
}
)
*/
Related functions
Other functions related to TeamDesk.Select are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy