Power BI

Completed

Connectivity to Google sheets

Vote (3327)

Power BI User on 04 Nov 2014 03:05:31

Connecting to Excel workbooks in OneDrive is a great first step, but connectivity to Google Sheets should be there too.

Administrator on 08 Mar 2022 00:02:27

Thanks for the suggestions! I've split out the other cloud storage options into separate ideas for people to vote on.

Comments (373)

Comments (373)

Linh Dinh on 05 Jul 2020 23:39:51

RE: Connectivity to Google sheets

I'm running into this error when trying to create a direct query connection to BigQuery using the built-in Google BigQuery connector

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Not found: Job [project-id]:[job-id]
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=Table

I follow the tutorial in this page and specify the BillingProject to mine. However, the above error pop up.

I check the job in BigQuery query history and it was marked successful. Hence, there's probably something wrong when Power BI is trying to get the data into Power Query.

My table is in the asia-northeast region, and when I try to query with a table in the US region instead, I find that it works.

Is this a bug with the REST API having something to do with region of the table?

P/S: I'm currently using the latest version of Power BI I believe (Version: 2.65.5313.1381 64-bit (December 2018)

Power BI Ideas Admin on 05 Jul 2020 23:39:42

RE: Connectivity to Google sheets

Custom segments!

Power BI User on 05 Jul 2020 23:39:09

RE: Connectivity to Google sheets

Custom Segments !

Shamsu Zoha on 05 Jul 2020 23:39:05

RE: Connectivity to Google sheets

Hi Team,
I really appreciate Power BI has made available Google Big Query custom connector.

I want to recommend, if Power BI comes up with Google Spanner connector.

I am requesting every one else to vote for this requirement.

Regards,
Shamsu Zoha