cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
moni_dd Frequent Visitor
Frequent Visitor

Single Sign On (SSO) to third party data sources (like SalesForce)

Please feel free to redirect to a different forum if this location is not OK.

Also - if this has been discussed already - please let me know. So far I did not find SSO topics related to 3rd party data.

 

Question is:

Is there a way to make a PowerBI report utilize SSO with a 3rd Party (data is outside the servers, domains, or Azure cloud-setup of our organization).

 

I know SalesForce offers SSO delegated approach based on Delegated Identity OpenID.

So can we install such a solution in our PowerBI cloud/gateway configuration?

If "not" - any plans to offer this in the future? It is really a critical option to have in an enterprise solution.

 

About what I found on the forum so far.

Two work-arounds were suggested in a separate thread I posted:

1. Use Row Level Security (RLS)

2. Develop the report using your own credentials. Save as template (*.PBIT). Give the template to users and they will be asked to re-authenticate when they create a report from this template.

 

2nd solution did not work out. At no point was the user asked for a password.

 

One way or the other - either solution is not workable in a prod environment, so my question on SSO.

Using RLS would mean to transfer the entire complexity of already established SalesForce rules into PowerBI.

Yes, doable, but a huge undertaking and once done will require work to keep rights in sync.

 

Using a template is not practical even if it worked. I cannot possibly go to my CEO and ask him to go over the motions, nor can I schedule an appointment to do the deployment myself from his PC. Even if I could, it is not just the CEO who needs the access but a whole department as well. And I have to do this every time there is a change in the report or when a users gets modified SF rights.

 

If I am missing something about the template solution - please let me know.

 

Many thanks for helping with this!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Single Sign On (SSO) to third party data sources (like SalesForce)

Hi @moni_dd,

 

I got the information that Power BI doesn't support SSO for data source now. And currently this is not listed on backlog.

 

For your requirement, you can vote this same idea: Add support for ADFS Smart Links.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: Single Sign On (SSO) to third party data sources (like SalesForce)

Hi @moni_dd,

 

I have sent a email to consult this issue internally. Once I get information, will let you know.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-qiuyu-msft
Moderator

Re: Single Sign On (SSO) to third party data sources (like SalesForce)

Hi @moni_dd,

 

I got the information that Power BI doesn't support SSO for data source now. And currently this is not listed on backlog.

 

For your requirement, you can vote this same idea: Add support for ADFS Smart Links.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

ocovault Occasional Visitor
Occasional Visitor

Re: Single Sign On (SSO) to third party data sources (like SalesForce)

Is there any update about this topic? I am trying to connect to salesforce to my custom domin (with SSO using ADFS).

 

Please let me know your feedback.

 

Regards,

 

OC

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)