Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.