Skip to main content

    Power BI

    Under Review

    Connectivity to Google sheets

    Vote (2990) 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 10 Jul 2020 16:04:37

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

    Comments (382)
    Power BI User's profile image Profile Picture

    d9131535 afc6-4979-bbf1-4e881739816f 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

    9e5f96e9 16b3-4823-93f7-6a8cb38d3798 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

    cf230814 f52a-4873-a74f-15e00aa63cd1 on 05 Jul 2020 22:32:03

    RE: Connectivity to Google sheets

    Totally agree with that!

    Power BI User's profile image Profile Picture

    0cee4438 d3f6-4cd5-b735-65c3ddc3fd71 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

    ac643e7c e800-ea11-a811-000d3a4f1ebb 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

    298904dd f82f-434c-bdeb-582cc28dc2db 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

    bd7f8d1c c71c-44d1-8403-cebe5c9b2163 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

    922271b9 611b-4c18-b321-f3e4f91102d4 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

    f95db4e9 868f-4741-aaf7-4daabd863c73 on 05 Jul 2020 22:30:48

    RE: Connectivity to Google sheets

    Integration with Google Firebase Analytics

    Power BI User's profile image Profile Picture

    c2031ea7 c047-4323-b473-db1559236d0d on 05 Jul 2020 22:30:28

    RE: Connectivity to Google sheets

    PowerApps has it... why don't you guys??

    :)