Hello All,
We are currently facing an issue with the Salesforce Connector for Google Sheets. We have been unable to export Salesforce reports to Google Sheets using the connector.
We are receiving the following error message:
"In order to get all of the report data, disconnect and re-authorize the Add-on from Salesforce using Help > Connection Information > Disconnect Add-on. Once disconnected, log in to Salesforce again using the Add-on."
Based on our initial findings, we suspect that this issue may have been caused by the recent MFA enforcement in the Production environment.
Each time a user tries to export a report, a new verification window opens and asks for an MFA verification code.
We are using the Salesforce Connector and have followed the instructions provided in the error message. After reconnecting, the export works only up to 2,000 records, and then the connection fails again.
Is there any workaround or recommended solution to prevent repeated MFA prompts and allow users to export reports successfully?
#Salesforce Admin #Security #MFA #Salesforce_connector
@Terrill Grubbs Haha no worries. I just tried that as well but it just popped right back up for me. We may just need to have folks switch over to pull via SOQL if it's going to be doing this. Thank you for the help!
