Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamically scheduling the dataset refresh in PBI Service

Hi, 

 

I have a report which is run on a quarterly basis. On each of the quarter months i.e. Mar, Jun, Sep and Dec, the user will run the report, after the first Friday of the month, on the following Monday. 

 

So the first Fri of the month can fall anytime from the 1st to 7th of the month, so the user wants the dataset refresh dynamically scheduled so that they get the updated data when they access the report on the following Monday.

 

Is this possible to schedule in PBI Service?

 

Thanks,

Vishy

Need Help
Show and Tell
Tips and Tricks

6 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    You can always go into the Power BI Service and manually refresh the dataset when you want it to be updated?

    Would that work

    If so you go into the App Workspace where the report is saved. Click on Datasets and then click on Refresh Now
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi GilbertQ ,

       

      Yes I can manually go and refresh the dataset when needed but was looking at ways to dynamically schedule the refresh if possible.

       

      Thanks,

      Vishy

  • ranbeermakin's avatar
    ranbeermakin
    Resolver III
    6 years ago

    Hi Anonymous 

     

    If you need more control over the refresh schedule, you may want to check Power Automate recurrence trigger and on that trigger refresh Power BI dataset.

     

    Let me know how it goes.

     

    Ranbeer

    If this post helped you, please accept it as the solution.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi ranbeermakin ,

       

      Ok let me check the Power Automate recurrence trigger, will let you know if that helps.

       

      Thanks,

      Vishy

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago
        Awesome that will help for sure.

        Just remember if you are using Power BI Pro you only got 8 refreshes a day.