Connect to Simba ODBC Big Query through Gateway

I could configure it using SIMBA ODBC Driver to BigQuery

Setps:
1- Create a service account for BigQuery, keep the email and JSON file with Keys
2- Install the ODBC driver locally and on the Server that have the Gateway the driver
https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

3- Configure the ODBC connection locally and on the gateway server, just open the ODBC (32 or 64 depending the driver you choosed) and edit putting the email and path to JSON keys:
 

4- On PowerBI Desktop choose ODBC has source 

5 - Choose Google BigQuery data sourse If you want to put a query go to advance options else just continue

6- Build your report and upload it.
7- Go to gateway management portal power bi and add a new data source of ODBC type
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-manage
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources
Configure like this (choose anynonymous authentication):

And it Works 🙂