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
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?
thank you! i found the run a query in optimize performance analyzer. I used your method, thank you!
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
this is a paginated report
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.