Salesforce.Data

Updated on

Salesforce.Data is a Power Query M function that returns objects from a Salesforce account based on provided credentials and environment. The function returns a table of objects from the Salesforce account.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Salesforce.Data(
   optional loginUrl as any,
   optional options as nullable record,
) as table

Description

Returns the objects on the Salesforce account provided in the credentials. The account will be connected through the provided environment loginUrl. If no environment is provided then the account will connect to production (https://login.salesforce.com). An optional record parameter, options, may be provided to specify additional properties. The record can contain the following fields:

  • CreateNavigationProperties : A logical (true/false) that sets whether to generate navigation properties on the returned values (default is false).
  • ApiVersion : The Salesforce API version to use for this query. When not specified, API version 29.0 is used.
  • Timeout : A duration that controls how long to wait before abandoning the request to the server. The default value is source-specific.

Other functions related to Salesforce.Data are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/salesforce-data