I have encountered an error as the following on the Google Bigquery data transfer service to extract facebook ads data:
Transfer run failed due to : <eye3 title='/ReaderService.ReadStream, PERMISSION_DENIED'/> generic::PERMISSION_DENIED: PERMISSION_DENIED: Exception was thrown by the Connector implementation: Error in executing ReadPartition request for asset with query SELECT ID,Target,AccountId,AccountStatus,Age,AmountSpent,Balance,BusinessCity,BusinessCountryCode,BusinessName,BusinessState,BusinessStreet,BusinessStreet2,BusinessZip,Capabilities,CreatedTime,Currency,MinCampaignGroupSpendCap,Name,OffsitePixelsTosAccepted,OwnerId,SpendCap,TimezoneId,TimezoneName,TimezoneOffsetHoursUTC FROM AdAccounts com.google.cloud.hosted.integrationservice.common.ConnectorStatusException: <eye3 title='PERMISSION_DENIED'/> generic::PERMISSION_DENIED: PERMISSION_DENIED: Exception was thrown by the Connector implementation: Error in executing ReadPartition request for asset with query SELECT ID,Target,AccountId,AccountStatus,Age,AmountSpent,Balance,BusinessCity,BusinessCountryCode,BusinessName,BusinessState,BusinessStreet,BusinessStreet2,BusinessZip,Capabilities,CreatedTime,Currency,MinCampaignGroupSpendCap,Name,OffsitePixelsTosAccepted,OwnerId,SpendCap,TimezoneId,TimezoneName,TimezoneOffsetHoursUTC FROM AdAccounts
Need your guidance to point us to the right direction to solve this issue please.
We have setup the app_id and app_secret in the facebook for business, we have also generated a long-lived refresh token as required for the bigquery data transfer service for facebook ads data transfer. All has seem to be setup correctly. However, the error still persists.
Alfin Rohadi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.