CData Power BI Connector for Google BigQuery 2019 - Online Help
Questions / Feedback?

Querying Data

CData Power BI Connector for Google BigQuery 2019 - Build 19.0.7354

Select a data connectivity mode when you create the connection to Google BigQuery in the Get Data window. The connector fully integrates Google BigQuery connectivity into the two data connectivity modes in Power BI: DirectQuery and data import.

Using DirectQuery

Use DirectQuery mode to work with the remote data in real time, rather than a local copy. As you define filters, aggregate fields, or join tables, the connector executes the underlying queries to Google BigQuery.

Note: DirectQuery mode is limited by the DirectQueryLimit connection property.

Using Data Import

Use data import mode to save a copy of the data in your report. As you make changes to your report, Power BI executes the underlying queries to the local cache, independent of the connector.

To synchronize your report with any changes in the remote data, click Refresh from the Home menu on the ribbon.

Advanced Connection Properties (optional)

This field allows you to specify properties for the connection. For example, PropertyA=Value1;PropertyB=Value2;

Advanced Options (optional)

This field allows you to provide a SQL statement that specifies what data to return. To configure this option, expand the Advanced Options area and then, in the SQL statement field, type or paste the SQL statement. Note that SQL statements are not supported in DirectQuery mode.

You can use the following types of SQL statements:

  • SELECT Statements extract data from a database. For example:
    SELECT * FROM Account
  • EXECUTE Statements call procedures that are stored in a database. For example:
    EXECUTE my_proc @second = 2, @first = 1, @third = 3;

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0