Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Salesforce API version with Power BI Salesforce integration

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 d...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

mark_carlisle's avatar
mark_carlisle
Advocate IV
6 years ago

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's avatar
twayland
New Member
3 years ago

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!