Skip to main content

Power BI

Completed

Connectivity to Google sheets

Vote (3327) Share
Power BI User's profile image

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)
Power BI User's profile image Profile Picture

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 User's profile image Profile Picture

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

RE: Connectivity to Google sheets

Custom segments!

Power BI User's profile image Profile Picture

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

RE: Connectivity to Google sheets

Custom Segments !

Power BI User's profile image Profile Picture

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

Power BI User's profile image Profile Picture

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

RE: Connectivity to Google sheets

Custom segments please!

Power BI User's profile image Profile Picture

Jeff K on 05 Jul 2020 23:38:56

RE: Connectivity to Google sheets

In November 2019, this idea will turn 5 and we can send it to school!

Power BI User's profile image Profile Picture

Toby Lawler on 05 Jul 2020 23:38:44

RE: Connectivity to Google sheets

Renaming the App would work but anyway to differentiate the App tiles would be helpful.

Power BI User's profile image Profile Picture

Milind on 05 Jul 2020 23:38:20

RE: Connectivity to Google sheets

Please implement this asap

Power BI User's profile image Profile Picture

Vitor Ferreira on 05 Jul 2020 23:37:57

RE: Connectivity to Google sheets

There is still no official tool to connect powerbi in googlesheet with access only to specific emails?

Power BI User's profile image Profile Picture

Michael on 05 Jul 2020 23:37:44

RE: Connectivity to Google sheets

Four years!!!! and I'm still waiting