Forum Discussion
How to connect BigQuery Sheets table using the Power BI connector?
Good day, I have a dataset in bigquery with some tables of data. One of this source table its a google sheets data. When i try to use the bigquery connector in Power BI i'm getting this error. I ...
Found any solution? Because I am having the same issue.
Hi all, a little late here but I found a solution that solves importing a BigQuery table (source - Google Sheet) to PowerBI. It's relatively simple - 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.
Hope this helps!