I am trying to install the last version of the package DLRS, and when i follow the link https://install.salesforce.org/products/dlrs/latest and choosed the Sandbox, i got the below Error after the login " We can't authorize you because of an OAuth error. For more information, contact your Salesforce administrator. OAUTH_APPROVAL_ERROR_GENERIC : An unexpected error has occured during authentication. Please try again. I searched here for similar errors, and even installed the Salesforce CLI app, as suggested by some users, but I still get the same error. Any suggestions?
I'm so sorry I didn't see this!
Were you able to resolve? If not, here's the solution that worked for me (copy-and-pasted from where I wrote it up in response to a feed question I posted):
Essentially, the 404-error meant that the Integration user did not have access to any reports. I
thought I had done that by assigning the "Salesforce API Integration" permission set license, but turns out that only gave me permissionto assign those permissions (facepalm).
If you are encountering this error with an Integration User, ensure you have the following permissions/settings enabled:
- The user should be assigned the Minimum Access - API Only Integrations Profile.
- Ensure that the Minimum Access - API Only Integrations Profile has the System Settings "API Enabled" and "API Only User" checked.
- Ensure that you have the Salesforce API Integration Permission Set License assigned to the Integration User. Scroll down to Permission Set License Assignments on the User page and then click "Edit Assignments" and add it there.
- Create a Permission Set with the following:
- IMPORTANT: Do NOT specify a License that the Permission Set will be used for. Leave it as "None."
- Enable the following System Permissions:
- Run Reports
- Export Reports
- View Reports in Public Folders
- Manage All Private Reports and Dashboards (if the report you will be targeting is a Private Report)
- In Object Settings, enable any permissions needed to view the data in the reports you will be using in Power BI. For my use case, I needed to grant "Read," "View All Records," and "View All Fields" for both Accounts and Opportunities.
- You can also enable the System Permission "Approve Uninstalled Connected Apps" which will prevent an authentication error from occurring when you first connect Power BI to your org.
- Assign the Permission Set to the Integration User
