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

    Bryan Campbell on 05 Jul 2020 22:30:28

    RE: Connectivity to Google sheets

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

    :)

    Power BI User's profile image Profile Picture

    Jonathan Schwarz 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

    Nika 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

    Valentyn 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

    Power BI User 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

    Ed Barnard 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

    Danilo Soto Villena 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

    Power BI User 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

    Valentyn 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

    Tyler Cumberford on 05 Jul 2020 22:28:48

    RE: Connectivity to Google sheets

    Come on guys. This request is approaching 2 years!