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

    William Drewett on 05 Jul 2020 22:32:30

    RE: Connectivity to Google sheets

    There is a work around.

    If you publish your Google Sheet (File>Publish to the web). You can point PoweBI to that web URL and import the data from the sheet

    Power BI User's profile image Profile Picture

    Kim Eskelinen on 05 Jul 2020 22:32:14

    RE: Connectivity to Google sheets

    Charles, I'd say it would be worth showing how to connect through current extension points

    Power BI User's profile image Profile Picture

    Spike Patching on 05 Jul 2020 22:32:12

    RE: Connectivity to Google sheets

    Pull your finger out microsoft! We need this

    Power BI User's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:32:03

    RE: Connectivity to Google sheets

    Totally agree with that!

    Power BI User's profile image Profile Picture

    Robert K. Bell on 05 Jul 2020 22:31:57

    RE: Connectivity to Google sheets

    We'd really appreciate being able to use string filters other than just "exact match" in GA queries. At the moment, selecting another type such as "starts with" breaks the 'Cube', forcing Power BI to request far more data than necessary.
    Even though the Core Reporting API supports such filters.

    Power BI User's profile image Profile Picture

    sadf sdf on 05 Jul 2020 22:31:53

    RE: Connectivity to Google sheets

    Hello Paco,
    Do you think it would be worth showing how to connect to different source through the current extension points i.e. REST, ODATA?

    Power BI User's profile image Profile Picture

    Tyler Cumberford on 05 Jul 2020 22:31:49

    RE: Connectivity to Google sheets

    Come on MS, AdWords is too important not to have it as a source!

    Power BI User's profile image Profile Picture

    Jesper Ellegaard on 05 Jul 2020 22:31:37

    RE: Connectivity to Google sheets

    I believe that the standard GA to PBI connector will only pull aggregates and will also be exposed to sampling.

    May I suggest using https://scitylana.com instead? Scitylana will pull all raw data, user by user, click by click unsampled from GA (free edition) into Power BI (and others). This expands the possibilities of web analytics dramatically and enables integration with your own backend data.

    Power BI User's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:31:10

    RE: Connectivity to Google sheets

    If you got to bing or google, mostly bing because it has a really nice layout, and type MSFT Stock. It shows a great visual. Has built in trends, statistics, time slice, would be great to create a dashboard with a few of these!

    Power BI User's profile image Profile Picture

    Bader Almuqbil on 05 Jul 2020 22:30:48

    RE: Connectivity to Google sheets

    Integration with Google Firebase Analytics