Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |