Forum Discussion
Salesforce Objects timing out almost every time now
skygriff,
Do you make serveral transformations in Query Editor of Power BI Desktop? If so, please create a new PBIX that just get the tables data with no transformation and see what's happen.
Also please post fiddler trace log of the refresh issue here.
Regards,
Lydia
Sorry just saw your post today and yes that's what I ended up having to do. I created a new connection to the Salesforce Object (Case Activities) and found that I can filter by dates, but once I do some more advanced transformations it will time out. It was never like this before, so all the work I did previously in the query editor is no longer working. So for now I'm just getting by with minimal transformations. I saw an update published yesterday, do you know if that made any improvements to the Salesforce Object connections? Thanks!
skygriff,
There is no official articles or blogs stating that there are salesforce object improvements in the new Power BI update. In your scenario, the time out issue is caused by large data and multiple transformations. I would recommend you create measures or calculated columns instead.
Regards,
LydiaAnonymous skygriff I'm having these issues as well. I have 3 reports that use Salesforce. All were built months ago, put on schedules and untouched for months. All 3 auto refreshed daily, twice a day, with no issues ever. Microsoft reported issues with Salesforce reports refreshing twice last month and that they had been taken care of, but my reports have never been the same since. 2 of them I can still successfully refresh at the desktop level, then publish to the service. The other report won't even do that anymore, and I have to refresh each table individually and skip over the two Salesforce tables that won't load. When I try to refresh them individually, I get this and it just never goes anywhere:
It's frustrating because I spent months building these, they refreshed fine on their own for months, now I'm having these issues out of nowhere after microsoft went down and there seems to be no answer to the fix anywhere. They claimed they have fixed the issue but I've never been able to recover.
Did you resolve this