Forum Discussion

PiotrStawicki's avatar
PiotrStawicki
Frequent Visitor
5 years ago
Solved

How to connect PowerBI with google docs via BigQuery

Hi all,   I have a problem with connecting Power BI dataflows (tried also dataset) to the BigQuery view based on google docs, shared in my organisation. The problem is not with connection to BigQu...
Dataflow
Need Help
  • PiotrStawicki's avatar
    PiotrStawicki
    5 years ago

    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.""