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

    fa5f0be7 8fbd-4144-a9eb-746c6639cad8 on 05 Jul 2020 23:44:16

    RE: Connectivity to Google sheets

    Custom Segments

    Power BI User's profile image Profile Picture

    73fb71cf 9541-4985-a624-68e33b4c1aef on 05 Jul 2020 23:42:58

    RE: Connectivity to Google sheets

    Custom Segments

    Power BI User's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:42:58

    RE: Connectivity to Google sheets

    Custom Segment

    Power BI User's profile image Profile Picture

    3a0c9b82 08e8-48f4-9641-2b43604f32b3 on 05 Jul 2020 23:42:38

    RE: Connectivity to Google sheets

    Custom Segments!

    Power BI User's profile image Profile Picture

    da7fb330 8dfe-42e1-a7c6-919f4bd94df7 on 05 Jul 2020 23:42:29

    RE: Connectivity to Google sheets

    Custom segments!

    Power BI User's profile image Profile Picture

    5b9911eb aab6-4a5a-b96a-d9daf765c07d on 05 Jul 2020 23:41:32

    RE: Connectivity to Google sheets

    Yes, please do it!!! Would love it!

    Power BI User's profile image Profile Picture

    02d7b701 0385-4222-b480-28460ec4818f on 05 Jul 2020 23:41:26

    RE: Connectivity to Google sheets

    Obviously needed, if Power BI wants to be a serious marketing tool

    Power BI User's profile image Profile Picture

    b496e748 81ad-4d2e-8ce4-cd58a62fa072 on 05 Jul 2020 23:41:15

    RE: Connectivity to Google sheets

    We really need this connector...

    Power BI User's profile image Profile Picture

    3c15d08a ddbf-485f-83a0-f79491088db4 on 05 Jul 2020 23:40:36

    RE: Connectivity to Google sheets

    Please let us get out of the dark ages

    Power BI User's profile image Profile Picture

    5c86fb09 712a-4e04-b40e-417c9f9c1663 on 05 Jul 2020 23:39:51

    RE: Connectivity to Google sheets

    I'm running into this error when trying to create a direct query connection to BigQuery using the built-in Google BigQuery connector

    DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Not found: Job [project-id]:[job-id]
    Details:
    DataSourceKind=GoogleBigQuery
    DataSourcePath=GoogleBigQuery
    OdbcErrors=Table

    I follow the tutorial in this page and specify the BillingProject to mine. However, the above error pop up.

    I check the job in BigQuery query history and it was marked successful. Hence, there's probably something wrong when Power BI is trying to get the data into Power Query.

    My table is in the asia-northeast region, and when I try to query with a table in the US region instead, I find that it works.

    Is this a bug with the REST API having something to do with region of the table?

    P/S: I'm currently using the latest version of Power BI I believe (Version: 2.65.5313.1381 64-bit (December 2018)