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

    3065dd75 24ba-4a79-a6f0-b949475df900 on 05 Jul 2020 22:30:28

    RE: Connectivity to Google sheets

    Yes this would really be helpful for marketing analytics and reporting. For some this would be crucial to chose a BI tool like this. Adding Bing Ads API as well would be great too: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14666316-integration-with-adwords-and-bing-ads

    Power BI User's profile image Profile Picture

    b2de4be7 1aa4-4459-bf3c-919eed2a6c03 on 05 Jul 2020 22:30:12

    RE: Connectivity to Google sheets

    Using bing for mapping is awful. It plots the Middle East somewhere in North America. Even changing data category doesn't help.
    Similar thing happens when i want to plot something in Malta. It plots in North America again because it turns out that Malta is a town in Saratoga County, New York, United States.

    Google is just smarter.

    Power BI User's profile image Profile Picture

    dc922554 ebd7-426e-ad3a-46cc390fb5f3 on 05 Jul 2020 22:29:58

    RE: Connectivity to Google sheets

    HI.
    It very easy to connect.
    In google sheet go into the File\Publish online.Generate link for your file.
    Copy the link and insert it to Power bi Get data from internet.

    Power BI User's profile image Profile Picture

    b1a39f2c 5e80-4818-9d7a-3ee78d33145a on 05 Jul 2020 22:29:55

    RE: Connectivity to Google sheets

    I also want to make backups and eventually change on the desktop a report that was made online

    Power BI User's profile image Profile Picture

    a73b45f7 db7c-48d4-8422-e07d71a12216 on 05 Jul 2020 22:29:44

    RE: Connectivity to Google sheets

    Being able to select a date range for the query is critical. Power BI is almost useless for detailed queries otherwise as the data returned is very highly sampled (for my large dataset).

    Power BI User's profile image Profile Picture

    6e622cfc 66dc-4aeb-bf06-baf9169d82c1 on 05 Jul 2020 22:29:26

    RE: Connectivity to Google sheets

    Good idea \o/ Thanks a lot :D

    Power BI User's profile image Profile Picture

    532a7288 9aa5-433e-8106-6c05fa2fc1d7 on 05 Jul 2020 22:29:02

    RE: Connectivity to Google sheets

    If someone wants to approach this, let me know. I have this component ready to go which has been integrated into other BI platforms, but want to collaborate with folks who are in the PowerBI space.

    Power BI User's profile image Profile Picture

    dc922554 ebd7-426e-ad3a-46cc390fb5f3 on 05 Jul 2020 22:28:55

    RE: Connectivity to Google sheets

    Hi. In google sheets go to File/Publish to the Web (Internet), copy the link and paste into Power BI to, get data from Internet))

    Power BI User's profile image Profile Picture

    298904dd f82f-434c-bdeb-582cc28dc2db on 05 Jul 2020 22:28:48

    RE: Connectivity to Google sheets

    Come on guys. This request is approaching 2 years!

    Power BI User's profile image Profile Picture

    84517f06 c02d-4747-85b4-0cf490c0d8a2 on 05 Jul 2020 22:28:43

    RE: Connectivity to Google sheets

    This really would be useful.