Facebook Ads Error: Unable to Validate Querying API for Each Account

While setting up a Facebook Ads connection, the following error may appear, even though the correct account permissions have been granted natively:

Unable to validate querying API for each account. No accounts found to query.

What causes the Unable to validate querying API for each account error?

This issue may occur when the Facebook Business Manager requires two-factor authentication (2FA), but the connection's authorizing user doesn't have 2FA enabled.

How to resolve the Unable to validate querying API for each account error?

To resolve the issue, do the following:

1. In Facebook, ensure you have enabled two-factor authentication. For more information, see Facebook's two-factor authentication documentation.
2. In Fivetran, go to your Facebook Ads connection page.
3. Select the Setup tab.
4. Click Edit connection.
5. Click Re-Authorize Connection. When prompted, log into your Facebook account and authorize Fivetran's access.
6. Click Save & Test.