Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Date Based Columns Not Updating in Direct Query

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?


Responsive Resident
Responsive Resident

@dkkip05 did you ever find an answer to this?

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors