Power BI Connector for Smartsheet

Build 23.0.8839

Data Model

The CData Power BI Connector for Smartsheet models the Smartsheet API as relational tables, views, and stored procedures. Views are tables that cannot be modified.

Static Tables

Some API objects, like Workspaces, Folders, etc., are indexed with 'Info_'. These are defined in schema files, which are simple, text-based configuration files.

Dynamic Tables

You can work with all the Sheets and Reports in your account using the connector. In addition to providing information about the static tables, the data model illustrates a sample of what your Sheets and Reports might look like. The actual data model will be obtained dynamically based on your user credentials.

When you connect, the connector gets the list of tables and the metadata for the tables by calling the appropriate Web services. Any changes you make to your Smartsheet account, such as adding a new table, adding new columns, or changing the data type of a column, will immediately be reflected when you connect using the connector.

Stored Procedures

Stored Procedures are function-like interfaces to Smartsheet. They can be used to search, update, and modify information in Smartsheet.

API Restrictions

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839