Use this connector to have Foundational scan and determine lineage and downstream impact for PowerBI.
This setup should take about 15 minutes.
Permissions: You need to be a Google Cloud admin for some parts of this setup.
Go into the IAM & Admin page of your Google Cloud account
Select “Service Accounts” in the left menu, and then select the relevant Google Cloud project
Create a new Service Account
Fill in the account details
Select a name (Can be any name you'd like)
Select the BigQuery Metadata Viewer and BigQuery Resource Viewer as the role for the account
Click Done to save the account
Now that the new account is created, select it from the Service Accounts page
Next, we need to add a key to the account. Click on the Keys tab, and then on the Add Key button
Create a new key
Select JSON as the Key type and click Create
To finish the setup in Foundational, download the newly created key to your local machine and then upload it to the BigQuery configuration panel in Foundational.