Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to refresh report everyday?

I have created a report based on Azure DevOps analytics using ODataFeed URL as data source. 

When team memebrs from my organization opens thie template and gives correct credentials, it will pull all data upto date and create reports. 

 

My questions is: What should be done tomorrow when they want to refresh the report? 

Currently, if I click refresh button it pulls all latest data and regenerate the report.

but is it ideal to pull all data everyday? or

should I have some setup that pulls just new data or

how to autimatically refresh report without having to click refresh button explicitly? 

 

Kinldy help with any suggestion you have on this concern. 

Thanks 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    I am hopeful that you have already configured incremental refresh Or is it a direct query.

     

    Now to refresh your report you to need make sure that your date parameter changes. To you to set it Today, yesterday or tomorrow. For that, you need to use relative Dates.

    This will depend on how the pages are configured.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak Thanks Amit. This service is all in cloud and using OData query. 

       

      venal Thanks for your solutions. 

      We don’t need a data gateway because all of data sources are in the cloud.

       

      I will let you know if your solutions works in couple days as I have other tasks before that to complete. 

      I will mark the solution that helps me the most. Thanks 

       

      Thanks you both for your time on this. 

       

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    Anonymous 

    https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources#on-premises-gateway-requirements

    You can Install the Gateway and enable the below settings.

     

    Power BI Service >> Settings >> Manage Gateways 

     

     

    Try to check with "Refresh Now" or "Schedule Refresh".

    If you have any concerns, please let us know.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more
    If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

     

    BR

    venal.