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.
Hi everyone,
Not sure how this works. So, if I create a Power BI query to Salesforce Objects, the report will show data based on my rights (which are pretty extensive in my organization). However, if a 'regular' user, who can, in Salesforce, see only his Accounts, uses my report, what will he see? Everything or only his Accounts, as given by Salesforce admins?
Thanks!!
Alice
Solved! Go to Solution.
I don't have Salesforce to test with so I don't know if that results in an import or live connection but I assume you specify credentials as part of the connection, correct?
The issue therefore is that the connection is configured with the credentials you specify, which sounds like that is not what you want.
You would want to build your own dataset model, or perhaps connect Live to the dataset created, create some RLS rules, create roles and put people in those roles in order to keep people from seeing everything.
You need to use RLS.
I'm not sure I understand your answer, Greg. What I do is:
Get Data / Online Services / Salesforce Objects / Connect
I don't have Salesforce to test with so I don't know if that results in an import or live connection but I assume you specify credentials as part of the connection, correct?
The issue therefore is that the connection is configured with the credentials you specify, which sounds like that is not what you want.
You would want to build your own dataset model, or perhaps connect Live to the dataset created, create some RLS rules, create roles and put people in those roles in order to keep people from seeing everything.
I'll keep digging, thanks. In the meantime, I'll read about Row Level Security and roles - good call!
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 | |
48 | |
19 | |
13 | |
11 |