Answered

Control if powerbi dataset is refreshed

(0) Share

Report

Posted on by Kellef

Hello,

im trying to create a flow where im trying to run a query to a dataset in PBI where i want to check if the dataset is refreshed then set in a condition, IF the dataset is refreshed...---> next activity = Export To File for Paginated Reports PDF , IF NOT check again in 30 minutes.

But im not getting this part ....

Anyone has a tips?

Best regards,

Kellef

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

srduval 1,796 Moderator on at

Like (0)

Report
Copy link

Link copied!

In the power bi report you are trying to run the query against, build the query (table) to show the max value you are testing for. Then turn on and start visual analyzer and refresh the visual. This will then give you the exact dax query you need to use.

Was this reply helpful? Yes No
Kellef 17 on at

Like (0)

Report
Copy link

Link copied!

this is a paginated report

Was this reply helpful? Yes No
srduval 1,796 Moderator on at

Like (0)

Report
Copy link

Link copied!

The run a query against a dataset step should be a power bi dataset, so with that dataset (in desktop) you can temporarily add a table to get your dax query and then discard it, it doesn't need to be published to the cloud, it's just the easiest way to get a prebuilt dax query

Was this reply helpful? Yes No
Kellef 17 on at

Like (1)

Report
Copy link

Link copied!

thank you! i found the run a query in optimize performance analyzer. I used your method, thank you!

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Kellef

If I am not mistaken, Evaluate returns a table. I suspect that you just want the max date from a table. Why not just use a MAX expression without Evaluate?

Are you asking how to add the logic that checks the returned date and either send a report or waits 30 minutes?

Was this reply helpful? Yes No