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

[Mimoune_Djouall]

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.