Forum Discussion
Advocate ISalesforce API version
Hi, Quest
Here are some references that may be helpful:- 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.
Advocate IThank 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
Community Support
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.DataBest 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.