Salesforce API version with Power BI Salesforce integration

[Anonymous]

Hi,

Does anyone know which Salesforce API version is used with Power BI Salesforce integration?

Looks like it is 29.0 or less because some objects and columns are not available when getting SF data and but can anyone confirm this?

I came to this conclusion because if I use other tools to query SF data and use API version 29.0 or less there, same objects and columns are not available but if I use version 30.0 the objects and columns which I would need are available.

And a question to MS Power BI teams, is there any plan to update Salesforce API to newer version?

BR

Aksa

[mark_carlisle]

I know this is an old topic but 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])

I was encounting the same issue with missing columns and only stumbled upon this in the Power Query M functions library when I was looking for something else.

Should be an advanced option with the UI in my opinion.

Source: https://docs.microsoft.com/en-us/powerquery-m/salesforce-data

[twayland]

Mark- this was SUPER helpful...  Salesforce is forcing us to move to v30.0 and we needed a solution for controlling the REST API version.  Now we just place it in the connection!  Easy peezy!

[LukeMcManagan]

This should be the solution. Thanks Mark!

[v-yuezhe-msft · Accepted solution]

@Anonymous,

I use Fiddler to capture the connection process to Salesforce object in Power BI Desktop, and find that the Salesforce API version is v29.0.



Currently, I haven't found any official inforation stating the plan the update Salesforce API to newer versiom. If you need to connect to salesforce objects that are supported by V30.0, you can use web connector in Power BI Desktop to connect to Salesforce rest api.

Regards,
Lydia