Forum Discussion

santoshhmsam50's avatar
santoshhmsam50
Frequent Visitor
1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    What is the output of the RangeStart variable?

     

    --Nate

    • santoshhmsam50's avatar
      santoshhmsam50
      Frequent Visitor

      the  RangeStart is  = 2022-09-08 00:00:00 and  data type it datetime Anonymous 

  • Anonymous's avatar
    Anonymous
    Not 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