Forum Discussion

alicialcaide's avatar
alicialcaide
Helper II
4 years ago
Solved

BigQuery - TimeStamp conversion prevents me from configuring Incremental Ref

Hello,

I have a report connected to a Big Query data source via the official connector. I tried to configure a date filter with two parameters (RangeStart and RangeEnd), but when I try to preview the Query Folding, it automatically adds a TIMESTAMP() when querying against BigQuery, so I get an error because it is not possible to compare DATETIME with TIMESTAMP in BigQuery.

 

Is it possible to prevent Power BI from translating the parameter like this when doing the Query Folding? As I'm not able to change the datatype in BigQuery because I'm not the owner.

 

Thanks. 

 

 

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi alicialcaide ,


    Please try to use a "timestamp" column in Google BigQuery, not "datetime".

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    4 years ago

    Hi alicialcaide ,


    Please try to use a "timestamp" column in Google BigQuery, not "datetime".

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • alicialcaide's avatar
      alicialcaide
      Helper II
      4 years ago

      Hi Liang,

       

      Finally, the problem was solved doing this because I asked the DataBase Admin to change it if it was not a problem for the rest of the process.

       

      Thank you.

      Regards.

      Alicia.