Forum Discussion
Advocate IIPowwer BI Desktop - Salesforce connector error
Hi Elina_Mirin ,
This issue might be caused by Salesforce’s recent MFA or SSO enforcement or expired cached credentials in Power BI Desktop application. Please check the below points :
- Expired or Invalid Cached Credentials
Go to Power BI Desktop then→ File → Options and settings → Data source settings
Select your Salesforce connection → Clear Permissions → Close & Reconnect Again
Then again try using salesforce creds.
- MFA or SSO Policy Change in Salesforce
Salesforce enforces Multi-Factor Authentication (MFA) and SSO token requirements time to time.
Check with Salesforce admin to confirm whether SSO settings or Connected App permissions were updated or not.
The Power BI connector must be whitelisted as a trusted connected application.
- Power BI Connector Update
Microsoft has updated several OAuth connectors (including Salesforce).
Please update the latest Power BI Desktop version.
Then remove and re-add the Salesforce connection.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Post ProdigyHi Elina_Mirin
If you're still stuck after the Salesforce admin checks, this kind of "single sign-on" error tends to come back periodically with the native connector - every time Salesforce tightens MFA/SSO policies or rotates Connected App permissions, the OAuth flow can break for whole tenants at once. Frustrating, especially when nothing changed on your side.
Worth knowing about as a fallback - there's an app on Salesforce AppExchange called Power BI Connector for Salesforce that uses its own Connected App on the Salesforce side, so it's not affected by the same SSO/Connected App resets that hit the native connector:
🔗 AppExchange listing: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577
A few things relevant to this exact pain point:
- Doesn't rely on the native Power BI ↔ Salesforce OAuth flow, so SSO policy changes don't break refreshes
- Works with integration / service users — your reports stop depending on a single end-user's session
- No 2,000-row limit that the native Reports connector inherits
- 30-day free trial, no credit card needed
- Setup docs: https://metricasoftware.com/docs/salesforce/
- Support if you hit a snag: https://metricasoftware.com/docs/salesforce/contact-support/
Happy to set up a quick demo if it's useful — we can walk through the SSO-independent setup and how to migrate existing reports. Just reach out via the support link.
Cheers,
Metrica team
Advocate IIHi, metrica! Thank you for your message! I have resolved this issue with the SFDC admin team - the issue was that when trying to login into Power BI Desktop, my contractor credentials were overlapping with my client's account credentials. So even though I logged in with my client's credentials, somewhere in the backend it was reading my contractor's credentials.