Forum Discussion

Olenard's avatar
Olenard
Helper III
4 years ago

Nativequery on simba odbc bigquery

Dear colleagues,

 

I am currently using odbc driver for gcp big query.

I would like to know if the nativequery is available o' this driver and how to activate it.

 

Thank you all

 

Best

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Olenard ,

     

    The following Power Query connectors support native database queries.

    Connector Type of native database query
    Azure Analysis Services database MDX or DAX query
    Azure Database for PostgreSQL SQL statement
    Azure Cosmos DB SQL statement
    Azure SQL Data Warehouse SQL statement
    Azure SQL database SQL statement
    DataWorld.Dataset dwSQL
    Essbase MDX statement
    FHIR FHIR Search
    IBM Db2 database SQL statement
    IBM Informix database (Beta) SQL statement
    MySQL database SQL statement
    ODBC SQL statement
    OLE DB SQL statement
    Oracle database SQL statement
    PostgreSQL SQL statement
    SAP HANA database SQL statement
    Snowflake SQL statement
    SQL Server Analysis Services database MDX or DAX query
    SQL Server database SQL statement
    TIBCO(R) Data Virtualization (Beta) SQL statement
    Vena (Beta) Model Query (MQL)

     

    For more details, refer to https://docs.microsoft.com/en-us/power-query/native-database-query#connectors-that-support-native-database-queries

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Olenard's avatar
      Olenard
      Helper III
      4 years ago

      Hi,

       

      thank you for your feedback. 
      so from my understanding the nativequery should be ok with the odbc. How comes this does not work with simba for gcp