Error in Visual: No matching signature for operator < for argument types: DATETIME, TIMESTAMP.

[rgjiang]

Hello dear Power BI experts,

I am working on a report that uses DirectQuery from Google's BigQuery database. I encountered the following error message in my visual where I want to view the datetime of some orders order_created_date_time  in a table:

OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: No matching signature for operator < for argument types: DATETIME, TIMESTAMP. Supported signature: ANY < ANY at [56:15].

According to the posts I found online this indicates that the data type in the column order_created_date_time cannot be compared because some of them have type DATETIME and some have type TIMESTAMP. However, I don't understand where this comes from as BigQuery displays its type as DATETIME.

The proposed solutions apparently involve changing the type of order_created_date_time in BigQuery to TIMESTAMP. But because I don't have write permissions, I can't do that.

I also thought about importing the data into Power BI instead of using DirectQuery, but I don't have those permissions either.

Is there a way to solve this inside Power BI only? Thank you, I appreciate any help!

[Evangeli123]

Where you able to solve this problem? If yes please share the solution here

[amitchandak]

@rgjiang , what is a calculation you are performing, which is causing that?

Please share that to check any alternate

[rgjiang]

I just posted a reply that was very misleading, sorry about that. This is the behavior I'm observing.

1. I create two tables of order_created_date_time. These are the same.

First I create two tables of order_created_date_time

2. I click on one row in the first table. The other one doesn't sychronize.

Then I click on one row in one table and the other one doesn't synchronize

3. This is the detailed error message.

After clicking on See details