Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vickyd
Helper V
Helper V

User level data security - Salesforce.com

This link mentions the following
"It’s important to note that users are responsible for the data they share: if a user connects to data sources using her credentials, then shares a report (or dashboard, or dataset) based on that data, users with whom the dashboard is shared are not authenticated against the original data source, and will be granted access to the report."

So does that mean, if I create a report based on Salesforce data (via connector) and share it with individual Sales Reps, they will see the entire report and not just the data that they have access to?

If yes, how else can user level security be setup so people only see what they should?

2 REPLIES 2
PowerBIGuy
Responsive Resident
Responsive Resident

You are correct the sales rep will see the entire report. Your only other option at this time is listed below from the same article. You would have to load your sales force data into a SSAS tabular cube. You would then be able to implement role level security.

 

Thanks!

 

An exception is connections to SQL Server Analysis Services using the Power BI Analysis Services Connector; dashboards are cached in Power BI, but access to underlying reports or datasets initiate authentication for the user attempting to access the report (or dataset), and access will only be granted if the user has sufficient credentials to access the data. For more information, see Power BI Analysis Services Connector deep-dive

Business Intelligence Architect / Consultant

Hope this will be addressed though and row-level security functionality introduced. If not, it leaves a giant gaping hole in the solution that just won't be accepted by Business Users. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors