Authorize Cube to run BigQuery reports as YOU.
This will allow you to connect Looker Studio using your personal credentials and view data according to your BigQuery permissions.