Query within Power Automate

pbi_besi — Wed, 18 Oct 2023 15:52:54 GMT

Hi,

I have used a Power BI query within Power Automate with the Power Automate step "Run a query against a dataset". Now, I want to make the date specification dynamic so that today's date is always pulled.

The query looks like this:

FILTER(

KEEPFILTERS(VALUES('Mail'[DateTimeReceived])),

AND(

'Mail'[DateTimeReceived] >= (DATE(2023, 10, 17) + TIME(15, 1, 40)),

'Mail'[DateTimeReceived] <= (DATE(2023, 10, 18) + TIME(15, 1, 40))

I would like to replace (DATE(2023, 10, 17) + TIME(15, 1, 40)) with utcnow(), but then it gives me the following error message:
'The template language function 'utcNow' expects its parameter to be of type string. The provided value is of type 'Integer'.

Can someone help me?

Thanks a lot!

Re: Query within Power Automate

Anonymous — Wed, 18 Oct 2023 20:15:16 GMT

Hii, once try this

FILTER( KEEPFILTERS(VALUES('Mail'[DateTimeReceived])), AND( 'Mail'[DateTimeReceived] >= ToString(utcNow(), "yyyy-MM-dd"), 'Mail'[DateTimeReceived] <= ToString(utcNow() + DateDiff(DAY, 1), "yyyy-MM-dd") ) )

topic Re: Query within Power Automate in DAX Commands and Tips

Query within Power Automate

Re: Query within Power Automate