Answered

Problem with expression in Power Automate

(1) Share

Report

Posted on by SK-24060311-0

I am trying to write an action “Query a dataset” and add the following the query:
EVALUATE ROW('TimeStamp', CALCULATE(MAX('RefreshTable'[RefreshTime])))

However, I keep getting "This expression has a problem". When I run the same in DAX studio the output is as expected.

I am a complete Novice in power automate, any help will be really great.

Categories:

Building flows

PowerAutomate.docx

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @SK-24060311-0

You should write expression simmilar to shown below

The reason why you got error is because u have written under expression section.

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

You can simplify the query like so:

EVALUATE {MAXX('RefreshTable',[RefreshTime])}

Note that the RefreshTime is largely meaningless. Power BI will happily refresh your old stale data over and over again. Instead, find a date from your fact table that better indicates freshness.

Was this reply helpful? Yes No
SK-24060311-0 12 on at

Like (1)

Report

Hi @Nived_Nambiar @lbendlin

Please ignore my previous comment. I combined your solution and the one recommended by @lbendlin. With both my flow is now running fine.

Thanks both for your help

Was this reply helpful? Yes No