Skip to main content
Microsoft Idea

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

Igor on 05 Jul 2020 23:25:44

RE: Connectivity to Google sheets

Support Google Drive/Sheets table for Google BigQuery.
Just need to add Google Drive scope (googleapis.com/auth/drive) to Power BI app.

Problem described here https://community.powerbi.com/t5/Integrations-with-Files-and/How-to-connect-BigQuery-Sheets-table-using-the-Power-BI/m-p/413567#M17099

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:27

RE: Connectivity to Google sheets

custom segments are one of the most important ways of slicing GA data, please add this to the update

Power BI User's profile image Profile Picture

Jordan on 05 Jul 2020 23:25:14

RE: Connectivity to Google sheets

Bummers the only way to access this is via Google Analytics.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:13

RE: Connectivity to Google sheets

This is essential when reporting accurate results against campaigns. a sampled value is of no use.

Power BI User's profile image Profile Picture

Jon on 05 Jul 2020 23:25:11

RE: Connectivity to Google sheets

This is crucial - also connecting to an Excel document in OneDrive without needing a business account is needed. I subscribe to Excel through Office365, I don't want to have to open a new subscription just to connect to an Excel document.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:54

RE: Connectivity to Google sheets

Please implement this, right now its a manual process thats time consuming.

Power BI User's profile image Profile Picture

sadf sdf on 05 Jul 2020 23:24:19

RE: Connectivity to Google sheets

This is not something the team is working on the short term but With the Custom Connectors SDK, it is also possible for 3rd party ISVs (either the data source owners or someone else) to create connectors against these data sources and expose them in Power BI Desktop.
As an example, somebody has already created a connector for Youtube Analytics using the Custom Connectors SDK: https://community.powerbi.com/t5/Community-Blog/Power-BI-Custom-Connector-Youtube-Analytics/ba-p/211547

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:19

RE: Connectivity to Google sheets

I'm not going to lie - I was going to roast you over the fact that you have Bing Ads and not Google Ads... Lucky I checked to see if you actually had Bing Ads before I did that, because I discovered you don't.

If you don't even have your own SEM ad platform in there, a competitor's obviously isn't going to be high on your list of priorities I guess. Kind of missing the boat entirely for MarTech.

I do appreciate the update though, regardless. Thanks.

Power BI User's profile image Profile Picture

Petr Krenzelok on 05 Jul 2020 23:24:15

RE: Connectivity to Google sheets

Recent Bing map "quality" of our location is so weak, that we think to go with the different BI package. ESRI does not cut it either. Please stop limiting users and provide the ability to display over the Google maps.

Power BI User's profile image Profile Picture

Marco Smulders on 05 Jul 2020 23:23:54

RE: Connectivity to Google sheets

Please add this to the usage metrics reports