Power BI Connector for FTP

Build 23.0.8790

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 FTP. Direct Query can be used when you cannot import data due to a large data set that may slow FTP, 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.8790