Salesforce API version

[Quest]

I have a dataflow with over 20 objects from Salesforce. I see that the default version of Sales force api in Power bi is 29. I want to use another version or the current version 

I tried this for example for one of the objects and this worked.

Source = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=47.0])

Is there a way, I can this for all the objects in the data flow or the Power BI environment level?

[jamesccelestial]

Hi,

I am new to power BI. I am looking forward to any resolutions that will be posted in this community.

Hope this would answer your question.

How to update the Salesforce API

• Download the specific datasets that are using the salesforce connection.
• Once you’ve finished downloading the dataset, Open to PowerBI Desktop.
• Click Transform Data > Transform Data
• Click the advance Editor
• Change the API Version to the desired version then click Done.

[Quest]

Thanks

[Quest]

Thank you for the response. My question was around how the API version can be changed. The data flow works fine now. But the default Salesforce API version of Power BI seems to be 29.0. I want this to be changed to a later version

[v-angzheng-msft]

Hi, @Quest 

You can change the API version used by Power BI by specifiying the API Version in the query using [ApiVersion=XX.X].

Source = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=47.0])

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.

Refer:
Salesforce.Data

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft · Accepted solution]

Hi,  @Quest 

Here are some references that may be helpful:

Known issues and limitations

• There's a limit on the number of fields a query to Salesforce can contain. The limit varies depending on the type of the columns, the number of computed columns, and so on. When you receive the Query is either selecting too many fields or the filter conditions are too complicated error, it means that your query exceeds the limit. To avoid this error, use the Select Query advanced option and specify fields that you really need.

API Request Limits and Allocations

Salesforce balances transaction loads by imposing three types of limits:

• Concurrent API Request Limits
• API Timeout Limits
• Total API Request Allocations

When a call exceeds a request limit, an error is returned.

Salesforce Reporting row number Limitations

Power Bi Integration with Custom Salesforce Objects. ( Not Reports)

Connect Salesforce to Power BI: 2 Easy Methods

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.