Forum Discussion
Power Bi Service - Salesforce API
With the help of Microsoft Support, a solution has been found! The issue turned out to be with Salesforce.
To resolve:
1. Go to Salesforce > Setup > Release Updates
2. Look for “Salesforce Platform API Versions 21.0 through 30.0 Retirement” and lick "View Update"
3. Click "Disable Test Run" near the bottom
4. Redo the credentials on your Power BI Service
5. Everything should be functional again
I'm having the same exact issue as you and the time frame is about the same too. None of the solutions mentioned here so far have been successful. This is a sudden issue, my scheduled refreshes for the same models have been working perfectly for months until now. Refreshes on Power BI Desktop work perfectly, it's only when I try refreshing online. I feel like this is a Microsoft issue related to some API verification check that's missing on Power BI online refresh.
I've looked at every potential issue in this article https://learn.microsoft.com/en-us/power-query/connectors/salesforce-reports especially the one regarding the "Lock sessions to the IP address from which they originated" setting in Salesforce with no success.
I have tickets open with Salesforce and Microsoft but noone has been able to figure it out.
Thanks, let me know if you have any success with the support tickets. I agree it seems like a sudden Microsoft issue on service and desktop works fine for me too.
For now I've had to revert back to using a devart odbc salesforce driver along with an on premise gateway we were using before we upgraded to the salesforce enterprise version that included the API.Let me know if your tickets get resolved as I had to separate out my salesforce stuff in my report so that they rest of the report would refresh which sucks.
