Power BI Connector for Microsoft Bing

Build 22.0.8462

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 Microsoft Bing. Direct Query can be used when you cannot import data due to a large data set that may slow Microsoft Bing, 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462