Power BI Connector for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839

Publish a Dataset

Publish a Dataset with Salesforce Marketing Cloud Account Engagement Data

Make sure that you have configured a system DSN associated with the connector and that the DSN succeeds when testing its connection. If you do not have a successfully configured system DSN, see Creating the Data Source Name for configuration help.

Then, create and publish a dataset as follows:

  1. Open Power BI Desktop.
  2. In the Home ribbon, navigate to Get Data > Other.
  3. Scroll down the Other list until you find CData Salesforce Marketing Cloud Account Engagement.
  4. Click CData Salesforce Marketing Cloud Account Engagement, then click Connect. PowerBI Gateway displays the CData Salesforce Marketing Cloud Account Engagement: Connector window.
  5. In Data Source Name, specify the name of a Salesforce Marketing Cloud Account Engagement system DSN (the default system DSN is called "CData PBI SalesforcePardot Sys"), then select Import mode and click OK. PowerBI Gateway displays the Navigator window. In the left pane are directories of available tables in the selected data source.
  6. Click the folders to open them, then select your desired tables using the checkboxes beside their names.
  7. Click Load. The selected data appears in the Data pane, at right.
  8. Create a visualization.
  9. When you are ready to publish, return to the Home ribbon.
  10. Click Publish.
  11. Sign in to your Power BI account, if prompted.
  12. Name and save the .pbix file for the dataset. The chosen dataset name will be reflected on powerbi.com.
  13. If prompted, sign in with the Power BI account associated with your Power BI Gateway installation.
  14. Select the workspace you would like to publish the dataset to and click Select. Wait for the publication process to complete.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839