Forum Discussion

kapilnath's avatar
kapilnath
Frequent Visitor
1 year ago
Solved

Power BI to Salesforce -SSO error

Hi , We are trying to connect to Salesforce using the custom url : https://keeley.my.salesforce.com/ . I always get SSO error. 
If I try to connect via google browser , I don't have any issue . Any suggestions ?

  • Hi kapilnath 

    On order to debug the connection issue, you can try several approaches:

    1. Verify SSO Configuration in Salesforce:

      • Ensure that the custom domain (https://keeley.my.salesforce.com/) is correctly linked to your SSO system.
      • Check the SAML settings in Salesforce and confirm they align with your organization's SSO configuration.
    2. Power BI Settings:

      • When connecting Power BI to Salesforce, try selecting "OAuth2" as the authentication method.
      • Make sure your Power BI Desktop is up-to-date, as older versions can cause compatibility issues.
    3. Access Permissions and Credentials:

      • Ensure Power BI is using the correct SSO settings during the connection process. You might need to select a specific domain or provide tailored credentials to avoid errors.
      • Consider using the "Sign in via Browser" option during the Salesforce connection setup in Power BI.
    4. Proxy or VPN:

      • If you're using a VPN or Proxy, they might be blocking the connection. Temporarily disable them and try again.
    5. Error Logs:

      • If there's a specific error code, check the logs in Power BI or Salesforce for more details.
    6. Browser Access Works:

      • If you can connect via your browser but not Power BI, it may indicate an issue with SSO permissions in the Power BI platform. Contact your Power BI or Salesforce admin to verify the setup.

    If none of these steps work, consider reaching out to Power BI or Salesforce support for tailored assistance.

    Link to opening the ticket to Microsoft support :
    https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/683031

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

1 Reply

  • Hi kapilnath 

    On order to debug the connection issue, you can try several approaches:

    1. Verify SSO Configuration in Salesforce:

      • Ensure that the custom domain (https://keeley.my.salesforce.com/) is correctly linked to your SSO system.
      • Check the SAML settings in Salesforce and confirm they align with your organization's SSO configuration.
    2. Power BI Settings:

      • When connecting Power BI to Salesforce, try selecting "OAuth2" as the authentication method.
      • Make sure your Power BI Desktop is up-to-date, as older versions can cause compatibility issues.
    3. Access Permissions and Credentials:

      • Ensure Power BI is using the correct SSO settings during the connection process. You might need to select a specific domain or provide tailored credentials to avoid errors.
      • Consider using the "Sign in via Browser" option during the Salesforce connection setup in Power BI.
    4. Proxy or VPN:

      • If you're using a VPN or Proxy, they might be blocking the connection. Temporarily disable them and try again.
    5. Error Logs:

      • If there's a specific error code, check the logs in Power BI or Salesforce for more details.
    6. Browser Access Works:

      • If you can connect via your browser but not Power BI, it may indicate an issue with SSO permissions in the Power BI platform. Contact your Power BI or Salesforce admin to verify the setup.

    If none of these steps work, consider reaching out to Power BI or Salesforce support for tailored assistance.

    Link to opening the ticket to Microsoft support :
    https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/683031

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.