Mimoune_Djouall's avatar
Mimoune_Djouall
New Member
4 years ago
Status:
New

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

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.

Recent ideas