You need Google Analytics permission to export data to Big Query.

Even though I am the owner of Google Cloud, this link button was inactivated when I was a viewer of Google Analytics property.

You may need to be the editor or administrator of the GA property. (I am not sure from which role the permission to export data starts)

FYI, the admin can change your role in Admin > Account > Account access management.