Forum Discussion
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 re...
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.
