topic Re: Microsoft Power Query Refresh update in Developer

Microsoft Power Query Refresh update

Anonymous — Thu, 23 Mar 2023 11:52:12 GMT

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

Re: Microsoft Power Query Refresh update

Anonymous — Tue, 28 Mar 2023 06:45:35 GMT

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

Re: Microsoft Power Query Refresh update

Anonymous — Tue, 28 Mar 2023 11:07:53 GMT

No I did not

Re: Microsoft Power Query Refresh update

Anonymous — Thu, 04 May 2023 13:19:19 GMT

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.

Re: Microsoft Power Query Refresh update

DanielRamos — Fri, 21 Jun 2024 19:18:08 GMT

Any updates on this? =/

Re: Microsoft Power Query Refresh update

lbendlin — Fri, 21 Jun 2024 21:15:13 GMT

Now running on v48

Re: Microsoft Power Query Refresh update

nikkrank — Tue, 20 Aug 2024 20:51:23 GMT

I am still getting this error.

Re: Microsoft Power Query Refresh update

valdano_34 — Thu, 17 Oct 2024 20:12:50 GMT

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

Re: Microsoft Power Query Refresh update

Anonymous — Mon, 18 Nov 2024 10:55:47 GMT

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

"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])

Re: Microsoft Power Query Refresh update

valdano_34 — Wed, 20 Nov 2024 15:45:54 GMT

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

Re: Microsoft Power Query Refresh update

lbendlin — Wed, 20 Nov 2024 20:09:10 GMT

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

Re: Microsoft Power Query Refresh update

valdano_34 — Wed, 20 Nov 2024 20:46:07 GMT

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