Unable to publish report that contains Salesforce data

[pconn]

Hello,

I have been trying to publish a Power BI report using Salesforce data. I am able to import the Salesforce data into Power BI desktop but when I go to publish the report, the data source will not accept my credentials. 

Error:

We can't authorize you because of an OAuth error. For more information, contact your Salesforce administrator.

OAUTH_APPROVAL_ERROR_GENERIC : An unexpected error has occured during authentication. Please try again.

I reached out to our Salesforce admins and they say since I am able to import the data into Power BI desktop, the error is not on their end. Our Power BI admins state everything is configured for salesforce. 

I have a Pro Power BI account and Salesforce admins confirmed API access is enabled on my profile.

I have tried to import and publish the data with both the default production link (salesforce.com) and company custom link (xxx.mysalesforce.com). Both result in the Oauth error.

When I try to log intoSalesforce outside of Power BI the mysalesforce.com redirects to a lightning URL and I am able to login without issue. When I try to log into the salesforce.com URL, I get an Oauth error. 

Can anyone point me in the correct direction for what the issue may be?

[pconn]

Sorry for the delay - I was finally able to get connected to Salesforce and it was definitly a miss on the Salesforce admin side. It took getting Salesforce customer support involved. 

The Salesforce admins had not installed both the PowerBI Query and PowerBI Query Refresh Apps under the 'approved apps' in Salesforce. Since I was able to import into PowerBI desktop, they assumed everything was set up already. Once they got the PowerBI apps installed I was able to enter my credentials and set up autorefresh. 

[v-achippa]

Hi @pconn,

Thank you for the response and confirming that the issue is resolved now. Thank you for being part of Microsoft Fabric Community.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @pconn,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @GeraldGEmerick and @grazitti_sapna for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or you have raised the support ticket?

Thanks and regards,

Anjan Kumar Chippa

[pconn]

I have sent @grazitti_sapna 's response to our salesforce team. I have not heard back yet from them but will update when I do. I have not opened a support ticket yet.

[v-achippa]

Hi @pconn,

As we haven’t heard back from you, we wanted to kindly follow up to check if you have got any response from the team or have raised the support ticket?

Thanks and regards,

Anjan Kumar Chippa

[pconn]

Hello @v-achippa I have pinged my salesforce admin again this morning and I have still not heard back. I will follow up when I have more information. 

[grazitti_sapna]

Hi @pconn,

If you are able to connect with same credentials from Desktop and not from service, then issue is on salesforce Side,

Ask your salesforce admin to lookk for below settings for authentication:-

verify the Power BI connected app has:

• IP Relaxation = Relax IP restrictions

• Permitted users = Admin approved users

• MyDomain OAuth enabled

• Refresh tokens not restricted

• MFA/SSO OAuth exemptions (if enforced)

This should be helpful to authenticate your access to Salesforce.

🌟 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!

[GeraldGEmerick]

@pconn You will likely want to open up a support ticket with Microsoft. Microsoft Fabric Support and Status | Microsoft Fabric