Forum Discussion

ghaines's avatar
ghaines
Resolver I
3 years ago

Managing Refresh Schedule

I work with a fairly temperamental data source and need to coordinate my scheduled refreshes on my on-premises data gateway carefully.  I maintain my own excel document so that I know when individual...
Dataflow
collinq's avatar
collinq
Super User
3 years ago

Hi ghaines ,

 

The "Manage Connections and Gateways" is only about setup for Gateways and Data Sources.  It doesn't have a schedule in that area.

 

The schedule for when a report is refreshed is in the settings for each Data Source individually.  Also, there is a "Refresh History" that shows how long each refresh took.

 

You could use the API to determine when your refresh starts and ends for each report and see what your overlap is.  The API's can be found here: Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

 

ghaines's avatar
ghaines
Resolver I
3 years ago

Hi Collin, thanks for your answer.

 

When you mentioned the refresh schedule is in the settings for each data source do you instead mean each report individually?  I cannot see anything in the settings for each data source under "Manage connections and gateways"

 

Those APIs look very useful, thanks for showing me that.

  • collinq's avatar
    collinq
    Super User
    3 years ago

    HI ghaines ,

     

    Yes, I mean for each report.  There is (in the APIs) the ability to see which reports are using which Data Source as well.