Forum Discussion

Yaotel's avatar
Yaotel
New Member
4 years ago
Solved

Can i use a common SQL Function in a Power BI importing query

Hi, i'm trying to import data from a MongoDB via ODBC Driver with this SQL Query:

 

SELECT column, NOW() FROM table WHERE orderDate >= DATE_SUB(NOW(),INTERVAL 5 DAY)

 

but the 'NOW()' function returns null. Apparently sql functions doesn't work in Power BI SQL queries. Is there any solution or other way to deal with that ? The query needs to happen at the same time as the import to limit the data.

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Yaotel ,

    Does a datetime field exist in your database? if so, try filtering using a field that actually exists in the database table.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Yaotel ,

    Does a datetime field exist in your database? if so, try filtering using a field that actually exists in the database table.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Yaotel's avatar
      Yaotel
      New Member
      4 years ago

      It really makes sense, I will try it. Thank you!

  • Syk's avatar
    Syk
    Icon for Resident Rockstar rankResident Rockstar
    4 years ago

    Try using 'GETDATE()' in place of NOW() and see if that helps

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    you could try something like this:

     

    declare @now datetime
    declare @lastweek datetime

     

    set @now = CAST(getdate() as date)
    set @lastweek = CAST(DATEADD(day, -5, @now) as date)

     

    SELECT [column] FROM [table]
    where [date] > @lastweek

     

     

    Regards,

    Max