Date Based Columns Not Updating in Direct Query

[dkkip05]

I have an Azure SQL Database that I am accessing using Direct Query Mode. I added a custom column to tell me if a transaction occurred today using the following:

=if [TxnDate]=DateTime.Date(DateTime.LocalNow()) then Logical.FromText("true") else Logical.FromText("false")

This seems to work in the Desktop version of Power BI, but when I publish the report, it doesn't seem to update the date. It's almost like it's stuck in whatever day the dataset was published. I was under the impression that datasets in Direct Query mode will update about every 10 minutes. Shouldn't it update the Queries as well? Or did I just write my Date function incorrectly?

[elliotdixon]

@dkkip05 did you ever find an answer to this?