Salesforce object DataSource.Error

Hi rjbnorth,

I have found a solution. It appears that the connector between PowerBI and Salesforce breaks down the ‘get columns string’ somewhere midway.

The solution that worked for me is the following:

1). Try to connect to a Salesforce object in PowerBI (the one you experience problems with).

2). Go to ‘Edit Queries’

3). Right click on the object in question and go to the ‘Advanced Editor’

4). The trick is to get only those Salesforce columns that you really need. This will bypasses the error that occurs in the long 'get string'

5). If you want more columns to be included. Place the Salesforce API field names in quotes (“”) and separate by comma’s (,). For example: {"Id", "Name", "OwnerId"}

I hope this is also a workable solution for you.

Greetings Ronald