Power BI Connector for Dynamics 365

Build 21.0.8137

Getting Data

After Installing the Connector and Creating the Data Source Name, you can connect to the data that you want to work with. After connecting to the data, you can edit or load the data to start building reports.

Connect to the Data

Complete the following steps to connect to the data:

  1. Click Get Data.
  2. Accept the warning to connect to a third-party service.
  3. Select All > CData Dynamics 365 in the Data Source Name menu.
  4. Select Connect.
  5. Enter the Data Source Name, Advanced Connection Properties (optional), and Advanced Options (optional).
    • Note that the default Data Source Name is CData Power BI Dynamics365, but you can change this name by editing the DSN configuration. See Creating the Data Source Name for more information.
    • See Querying Data for more information on the optional fields.
  6. Select a data connectivity mode and click OK. See Querying Data for more information on each mode.
    • Select Import to import a copy of the data into your project. You can refresh this data on demand.
    • Select DirectQuery to work with the remote data.
  7. In the Navigator window, expand the CData Power BI Dynamics365 folder, then expand the associated schema folder to see a list of available data (tables, stored procedures, or views).
  8. Select the box next to the data that you want to work with.
  9. Select Load or Edit. See the next section for more information on these options.

Load or Edit the Data

After connecting to the data, load or edit the data, as described below.

  • When you click Load, the connector executes the underlying query to Dynamics 365.
  • When you click Edit, the Query Editor launches and a representative view of the table is presented. You can use the Query Editor to adjust the query and query results before you load the data. Right-click a column header to perform actions like the following:
    • Rename columns or tables
    • Change text to numbers
    • Remove rows
    • Set the first row as headers

Next Step

After getting the data, you can create visuals and reports. See Visualizing Data for more information.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137