Salesforce Object Refresh

[Brijesh]

I'm new to power BI and have no clue why this has happened?

I have three different dataserts all has data source as "salesforce objects". I've built reports using salesforce objects and were on an auto refresh schedule of once a day. 2 of my reports is refreshing fine without any issue but but one report doesn't refresh at all anymore even from the desktop. It is not showing me any new data after 26th April 2019. Also when I tried to refresh on desktop manualy it run the refresh cycle successfully but NO new data loaded! And surprisingly two of other datasets are refreshing well without any issue - even on PBI service. All three datasets are using almost similar salesforce objects but has different set of information based on requirements. 

Microsoft support has been everything but helpful. Has anyone out there experienced the same thing? How did you fix it? I have project deadline to deliver this by end of this month. If I cannot fix this I won't be able to hand this over to the business for them to use.

I haven't changed anything at all in the report anywhere, it just no longer seems to want to deal with Salesforce. I built the report months ago and set up the refresh schedule and haven't touched it. 

When it tries to refresh on PBI service it gives below error;

The last successful refresh was on 12th April 2019, see below refresh history for this dataset;

Looking forward to get some genius solution.

Thank you,

Brijesh

[QueryWhiz]

Hi, @Brijesh were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. 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-piga-msft]

Hi @Brijesh ,

Here is a similar thread which has a solution from GCL , you could have a try.

If your problem is very urgent, you could create a support ticket there to get the most fastest and targeted solution.(If you have Pro license.)

Best  Regards,

Cherry