Forum Discussion
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 🙂
" 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.""
Community SupportHi, PiotrStawicki
I would like to ask, when you connect to the data source, whether there is a query executed on the BQ, which can cause problems.
Best Regards
Janey Guo
Hi,
I'm sorry for late response. I'm not sure how to check or answer to this question, but I could easily connect correctly to this BigQuery view by other environments, for example by BigQuery consone and read the data using some standard queries, so I suppose the problem is not on BigQuery side.
The problem occured only trying to connect to this view by Power BI query editor
But as I mentioned in my last comment, the solution that I found in some other thread helped and it works this way. So I think you can close this thread because problem is solved, thanks for your support 🙂
Regards,
Piotr