Connecting Excel with BigQuery data

I am have trouble getting Excel to accept the google BigQuery connection key when I attempt to connect my BigQuery SQL to Excel.  The pop-up states "bad parameter.  looking for different kind of key"