-
Thank you for your question. If you are not seeing the dimensions and metrics in the dropdown list of the ‘Google Analytics Data API’ in SSIS, it could be because the token you are using does not have the necessary permissions to access them. As a result, only the dimensions and metrics that you have access to are being displayed.
To resolve this issue, you can try granting the account that is authorizing the token the appropriate permissions. This can be done by ensuring that the account has the necessary access rights in the Google Analytics console. Once you have updated the account’s permissions, you will need to generate a new token.
After generating the new token, try using it in the SSIS component and check if the dimensions and metrics you are looking for are now populated in the dropdown list. If they are, it means that the permissions issue has been resolved successfully.
We hope this explanation helps you. Please give it a try and feel free to share any updates with us if you need further assistance.
