Skip to main content

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.