Power BI Connector for Smartsheet

Build 23.0.8839

Direct Query

Using the Direct Query Method

Use the Direct Query method to work with remote data in real time, rather than importing a local copy. As you define filters, aggregate fields, or join tables, the connector executes the underlying queries to Smartsheet. Direct Query can be used when you cannot import data due to a large data set that may slow Smartsheet, or in the event the data is actively changing and needs real-time updates.

Direct Query Limit

The Direct Query method is limited by the DirectQueryLimit connection property. If all of the following are true, the limit is replaced from the query to the settings in DirectQueryLimit.

  • The QueryPassthrough=false
  • The query is a SELECT
  • There is a LIMIT clause or equivalent (like TOP)
  • The value of the LIMIT is greater than allowed by DirectQueryLimit settings

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