How can I create dynamic date field in direct query report?

[vozniak]

I have a report that a colleague developed that uses direct query against our Oracle database. There are multpile hundreds of thousands of entries in the database that we need to query against in real time so it needs to be direct query. However, I need to fit it to our standard and therefore need to put a dyanmic field that gives the date and time the report was generated. I know how to create a date table, and I know how to create the dynamic field to show the date and time, but in a direct query report I can't create a new table.

Is it possible to create a dynamic date field showing the current date and time in a report that uses direct query? I can't make any changes to the Oracle database we are drawing from.

Any suggestions would be appreciated.

Thanks!!

[v-yulgu-msft · Accepted solution]

Hi @vozniak,

You can create a measure to display current date and time in a card visual:

New measure=NOW()

Regards,

Yuliana Gu

[vozniak]

Thank you!!

For some reason I can't select "Accept as Solution" but this what I was looking for. My brain just wasn't going in the right direction.