Forum Discussion
DataSource.Error:ODBC: ERROR [42000] [Microsoft][BigQuery] (70)
I am using Bigqery to get the Data in power BI with values as let data = Value.NativeQuery(GoogleBigQuery.Database([BillingProject="account"]) {[Name="XXXXX6"]}[Data], "SELECT *#(lf)FROM `Y...
Seems like you are comparing 2024-09-23 11:28:50Z, a datetimezone to 2022-09-08 00:00:00, and the BQ value is 2024-09-15T00:00:00. I don't know if one of these is actually a text value, but I would try making the format of the Power Query datetime match the database format, which I guess is UTC Zulu time.
--Nate