The Project IDs drop-down menu does not auto-populate options with the Project IDs available in the Google BigQuery database.

Workaround

1. Manually type in the Project ID and make the connection.
2. When making the database connection, use the New OLE DB Connection option.
   1. On the Insert tab, click the Connections drop-down menu. Select the 'New OLE DB Connection' option for the database.
   2. In the Data Link Properties dialog box, select 'Microsoft OLE DB Provider for ODBC Drivers'.
   3. Configure the parameters.
      1. Select Google BigQuery for Data Source Name.
      2. Insert the same credentials as used for the database.
      3. Click the drop-down menu for the initial catalog to use (Note: this is by default, auto-populate).
3. Test the connection.
4. Click OK.

Schritte zur Reproduzierung