Power BI Connector for Azure Data Management

Build 20.0.7587

Querying Data

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

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 Azure Data Management.

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 20.0.7587