How to connect PowerBI with google docs via BigQuery

Hi v-janeyg-msft and thanks for your answer.

The dataflow which I'd like to configure bases only on this single view. But unfortunately Datasource Credentials do not apply there, as the error pops up earlier, when I try to configure the query for the first time. With this error, it's impossible to even save & close the dataflow edit mode, so also configuring the credentials in settings.

Anyway, I found one solution in some other thread, which maybe is not the most efficient but so far it works in my case 🙂  

Thread: https://community.powerbi.com/t5/Power-Query/How-to-connect-BigQuery-Sheets-table-using-the-Power-BI/td-p/398543

" Schedule a query in BQ (e.g. SELECT * FROM [name of your google sheet table in bigquery]) and run that daily to ensure you capture new changes in the Google sheet. This allows you to store the results of your scheduled query in a separate table which you will then use in PowerBI. This way PowerBI doesn't have to authenticate with Google Sheets.""