Forum Discussion

kristenlooser's avatar
kristenlooser
Regular Visitor
1 year ago
Solved

Error connecting Power BI to Google BigQuery

Has anyone seen this error before, it has been preventing all new and existing reports from connecting to the data since 3/25? DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) HTTP E...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi kristenlooser ,

     

    Please refer to the steps in this document.

    Google BigQuery connector - Power Query | Microsoft Learn

    Please note:
    This error occurs when you refer to a resource (a dataset, a table, or a job) that doesn't exist, or when the location in the request does not match the location of the resource (for example, the location in which a job is running). This can also occur when using table decorators to refer to deleted tables that have recently been streamed to.

     

    Try:
    Fix the resource names, correctly specify the location, or wait at least 6 hours after streaming before querying a deleted table

     

    Hope this helps!

    Thank you.