Skip to main content
Microsoft Idea

    Power BI

    New

    Preserving Data Types With SQL Queries In Power Query And Power BI when Using BigQuery and other Connectors

    Vote (2) Share
    Mimoune Djouallah's profile image

    Mimoune Djouallah on 19 Nov 2021 05:19:51

    Currently when running a custom SQL Query using BigQuery, PowerBI send another Query just to check the Data type, it slow the performance and honestly it is not necessary, this behavior was fixed for SQL Server as per Chris Webb blog here

    https://blog.crossjoin.co.uk/2021/09/12/preserving-data-types-with-sql-queries-in-power-query-and-power-bi/

    can we have please the same behavior for BigQuery please.