Overview:
Sometimes, a user may need to query a Profile in Salesforce for the integration application.
When querying a Profile in CRM, the following error appears: Error - No such column PermissionsEditPublicReports on entity Profile. But the query was working normally before.
Root Cause:
The option Enable access levels for sharing report and dashboard folders is activated in the org.
The activity is recorded in the Setup Audit Trail also:
Activating this feature removes the Manage Public Reports Administrative Setting as well as the SOQL column PermissionsEditPublicReports on entity Profile. This causes the failure of the original query although it was working prior.
Solution:
Remove the field PermissionsEditPublicReports from the query.
Related Documentation:
CRM Help Documentation: N/A