Smartsheet.Tables

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 table

Description

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:

• Smartsheet.Content
• Smartsheet.Query

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