on premise gateway - not working for refreshing 1 file

[Eptor]

Hi,

I have created a report using the desktop app  which is a combination of SFDC data and 1 file.

I set in PowerBI on the data sources of the file the same path as in the desktop app.

As soon as try to set the "Refresh Schedule" and select the gateway I receive the following error:

 "Something went wrong

Failed to use the selected gateway. Please make sure the gateway is up and running and try again.
Please try again later or contact support. If you contact support, please provide these details.

Activity IDa85481ac-f608-4a96-8043-b03f01438a2a

Request ID0f2b1833-61d9-7059-f597-a16a2b1a9839

Correlation ID0454d469-4a0c-38e2-047f-07efca01adea

Status code400

TimeWed Mar 22 2017 17:48:55 GMT+0100 (Central European Standard Time)

Version13.0.1700.1439

Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net"

Gateway seems fine, and I checked that is the same path like 20 times.

Any ideas of what can be the reason of the error?

Thanks

[CoderZen08]

Hi @Eptor were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector, which pulls data directly from the SF objects API and therefore does not require a gateway to refresh. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[v-qiuyu-msft · Accepted solution]

Hi @Eptor,

From your description, it seems that the the dataset have two data sources SalesForce and File, right?

As SalesForce is a online service which is not supported in data gateway. In this scenario, you need to use the personal gateway instead of the on-premise data gateway. See this similar thread: How do I add a Salesforce Connection as a data source in corporate gateway?.

Best Regards,
Qiuyun Yu

[Eptor]

Thanks a lot.

I have managed to resolve the problem partially with the personal gateway. Getting there.