Power BI Connector for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839


Retrieve and modify campaigns.

Table Specific Information


The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • Id supports '=', '<', '<=', '>', '>='.
  • Name supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Campaigns WHERE Id = 43
SELECT * FROM Campaigns WHERE Name = 'Website Tracking'


This table does not have any required attributes when performing an insert.


Name Type ReadOnly References Description
Id [KEY] Int64 True

Pardot ID for this campaign.

Name String False

Campaign's name.

Cost Integer False

Cost associated to the campaign.

CrmFId String True

The CRM FID associated to the campaign.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CreatedAt Datetime

Filter by the creation time.

UpdatedAt Datetime

Filter by the modification time.

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