Microsoft Power Query Refresh update

[Anonymous]

Does any one have a solution for updating Microsoft Power Query Refresh API version (V29). Salesforce sent a notification that it is now outdated.

[Yo-F]

This may help: https://forcewalk.com/salesforce-summer23-api-v21-30-retirement-summer25-integration-problem-with-mi... 

"To be able to make PowerBI use the desired Salesforce APEX API version, Data or Business consultants have to mention the API version to use, directly in the connexion configuration (Salesforce Login URL could be replaced by the domain name URL of the concerned Salesforce instance) : 

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

"

[valdano_34]

Thanks for this, indeed this seems to resolve it, however:

there is some loss of functionality if one is using [CreateNavigationProperties = true], since the Source statement can only take 2 parameters: 

Source = Salesforce.Data("https://na126.salesforce.com", [CreateNavigationProperties = true])

so [CreateNavigationProperties = true] needs to be replaced by [ApiVersion=57.0], which isn't ideal since the 

[lbendlin]

Source = Salesforce.Data("https://na126.salesforce.com", [CreateNavigationProperties = true, ApiVersion = 57.0])

[valdano_34]

That worked out perfectly - thank you much, learned something new today !

[valdano_34]

Hi there,

The Summer'25 is approaching fast and I also got this error message - can someone from the MSFT support answer how this is going to be addressed, please ? 

Thanks,

Vladimir

[DanielRamos]

Any updates on this? =/

[lbendlin]

Now running on v48

[nikkrank]

I am still getting this error. 

[nolanmorris]

Hi, looking at the same issue. However Salesforce delayed the legacy API retirement until summer '25, so hopefully an update will come through by then.

[Anonymous]

No I did not

[Anonymous]

Hi did you get solution for this from any other portal?