Salesforce.Reports

Updated on

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

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

Syntax

Salesforce.Reports(
   optional loginUrl as nullable text,
   optional options as nullable record,
) as table

Description

Returns the reports 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:

  • 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.Reports are:

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