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 `YYYt`#(lf)
WHERE DATETIME(update_day) > DATETIME('2024-09-14T08:26:01') #(lf) AND DATETIME(update_day)< DATETIME('2024-09-21T08:26:01') ", null, [EnableFolding=true]),
#"Kept First Rows" = Table.FirstN(data,200),
RowToReturn = if AllOrSmall = "A" then dep_segment_equations else #"Kept First Rows",
#"Filtered Rows" = Table.SelectRows(RowToReturn, each [update_day] >= RangeStart and [update_day] < RangeEnd)
in
#"Filtered Rows"
My update_day in BQ is Datetime like "2024-09-15T00:00:00"
AS i am getting the error like
- Data source errorDataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: No matching signature for operator >= for argument types: DATETIME, TIMESTAMP Signature: T1 >= T1 Unable to find common supertype for templated argument <T1> Input types for <T1>: {TIMESTAMP, DATETIME} at [38:7]. DataSourceKind = GoogleBigQuery. DataSourcePath = GoogleBigQuery. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). . The exception was raised by the IDbCommand interface.
- Cluster URIWABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
- Activity ID448d5f7a-76ce-49c0-a698-fc5f4232396c
- Request ID6b6501df-5c88-b03c-a1c2-575712ce1eb1
- Time2024-09-23 11:28:50Z
edhans ,
5 Replies
- AnonymousNot applicable
What is the output of the RangeStart variable?
--Nate
- santoshhmsam50Frequent Visitor
the RangeStart is = 2022-09-08 00:00:00 and data type it datetime Anonymous
- santoshhmsam50Frequent Visitor
Asking more experts @ibendlin
- santoshhmsam50Frequent Visitor
- AnonymousNot applicable
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