Authentication issue with trying to connect to Salesforce

Hi jasonyeung87 ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

Thank you

Thanks for letting us know, Jason!

Hi jasonyeung87 

Glad you got it working! The platform integration user issue is a known limitation - the native connector relies on interactive OAuth, which doesn't suit headless service accounts.

If this comes up again (or for anyone landing here from search), there's an alternative worth knowing about — Power BI Connector for Salesforce, available on Salesforce AppExchange:

🔗 AppExchange listing: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

Why it tends to help with this exact use case:

• Designed to work with integration / service users without the interactive OAuth dance — so a password change on a regular user won't break your report
• No 2,000-row limit that the Salesforce Reports API imposes on the native connector
• 30-day free trial, no credit card needed
• Clear setup docs: https://metricasoftware.com/docs/salesforce/
• Responsive 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 integration-user setup, show how the data flows into Power BI, and answer any questions about your specific scenario. Just reach out via the support link above.

Cheers,

Metrica team