)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
“Insufficient privileges” errors occur when users lack the specific permission combinations required for dashboard access, even when sharing appears configured correctly. This reflects Salesforce’s complex privilege hierarchy where multiple permission types must align perfectly for successful dashboard viewing.
Here’s how to create data access paths that operate independently of Salesforce’s permission matrix, eliminating privilege dependency entirely.
Create privilege-independent access using Coefficient
Coefficient eliminates privilege dependency by using your admin-level API connection to access all necessary data, then sharing through spreadsheets that use simpler, more predictable permission models. This provides data access without requiring recipients to have specific Salesforce privileges.
How to make it work
Step 1. Import dashboard data using administrative access.
Use Coefficient’s comprehensive Salesforce integration with your admin privileges to access all necessary data. Configure imports to include all fields that users should see, regardless of their individual field-level permissions.
Step 2. Use Custom SOQL Query for complex privilege requirements.
For data relationships that might require special privileges in Salesforce, write custom SOQL queries to join multiple objects and create comprehensive datasets without privilege dependencies.
Step 3. Apply filtering for role-appropriate data views.
Use Coefficient’s filtering system to control data visibility without Salesforce privilege dependencies. Create multiple imports or sheet tabs to provide role-appropriate data views based on spreadsheet sharing rather than Salesforce privileges.
Step 4. Set up automated refresh without privilege re-validation.
Configure refresh schedules to maintain data currency without requiring privilege re-validation. Use dynamic filtering for user-specific data access that doesn’t depend on Salesforce user configurations.
Eliminate privilege management complexity
This approach transforms privilege-based access barriers into straightforward data sharing with reliable, consistent access for all intended users. Recipients get data access without Salesforce privilege requirements or ongoing permission management. Start using Coefficient to create dashboard sharing that works regardless of user privilege levels.
