Skip to main content

Notifications

Power Automate - General Discussion
Answered

Control if powerbi dataset is refreshed

(0) ShareShare
ReportReport
Posted on by 17

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.

 

Kellef_0-1712838395551.png

 

But im not getting this part ....

Kellef_1-1712838429945.png

 

Anyone has a tips? 

 

Best regards,

Kellef

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Control if powerbi dataset is refreshed

    @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?

     

  • Kellef Profile Picture
    Kellef 17 on at
    Re: Control if powerbi dataset is refreshed

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

  • srduval Profile Picture
    srduval 1,663 on at
    Re: Control if powerbi dataset is refreshed

    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

  • Kellef Profile Picture
    Kellef 17 on at
    Re: Control if powerbi dataset is refreshed

    this is a paginated report

  • Verified answer
    srduval Profile Picture
    srduval 1,663 on at
    Re: Control if powerbi dataset is refreshed

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard