Salesforce Refresh

Hi !! 

I am using only Salesforce and it´s does not refresh automathicaly. I tried adding a schedulled refresh but did not work. 

Any idea what I should be checking?

thanks!

Thanks, I managed to get the gateway up and running.

Thank you for your help

Hi ariankrakov, you're not the only one; I have multiple service reports whose data i'm fetching from salesforce and these days, it keeps dropping the credential from the dataset settings more frequently, almost every refresh (multiple times in single day).

I get email alert for refresh failure and have to re-enter the credential from the datasets (sometimes ask for password, sometimes just sign in) and then force refresh the data.

It is quite frustrating that MS is not focusing on the major connectors... 

hi, I am using only salesforce and its not refrshing automaticaly. I also created a schedulled refresh and did not work. Any idea what I should be looking into? 

thanks!

k3rz0rg& ariankrakov, I'm having similar issues with the Salesforce data set refreshing. My desktop app is fine and displays everything as expected. However, something gets corrupted with the powerbi.com data set refreshing schedule. It feels like my Salesforce credentials fail to save within powerbi.com.

I've also found that manual refreshing from the desktop app and republishing to the online version is a work-around, but I need the refresh schedule to work so my overseas stakeholders are not reliant upon me being plugged in 24/7.

Hi rkoretoff ,

the only workaround I found is having only one connection per report. Previously I had 3 to 4 table added to a report different times ended up having 3 connections. After multiple hour long conversation with the microsoft support guy, only useful solution he could come up with only if I could merge em all into single connection (which I didn't really wanna, that means re-creating the whole thing again); so I did re-create the report with one connection and added those tables all at once and running fine since then.

I re-polished other reports with salesforce connections and been working fine since then. Just marge em all into single link or minimize the number of connections. Hope that might work.

-K3

I am pulling multiple reports from SFDC and excel sheets and they all seem to be working ok for the automatic refreshes. 

I am using a virtual machine which the IT department setup so that it is online all of the time. This is where I have the gateway installed. 

The excel sheets are on a shared drive which the Virtual Machine has access to. The only time I get issues is when the IT department does some maintenance and the VM goes offline. Other than that it works fine. 

Hi ariankrakov 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 works normally when setting the refresh on PBI service. 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.