Smartsheet.Tables is a Power Query M function that returns a nested table of available sheets, reports, folders, and workspaces from the Smartsheet API.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Smartsheet.Tables() as tableDescription
Returns a nested table of available sheets, reports, folders, and workspaces from the Smartsheet API.
Examples
Returns sheets, folders, reports, and workspaces available at the top level of the Smartsheet hierarchy
// Output: A table of folders, reports, and workspaces from the top level of the Smartsheet hierarchy
Smartsheet.Tables()Related functions
Other functions related to Smartsheet.Tables are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy