Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Automatic dataset refresh

Hi,

 

I hve created several Reports on Power BI Desktop. I have to refresh it manually everyday whenever the dataset is updated and then agagin have to publish it on service so that my users, with who I have shared the reports can also see the updated version. Is here anyway to refresh the dataset automatically on Power bi service whenever the dataset (my datasource is updated). I am no developer so please finda solution from the data analyst perspective.

 

Thanks & Regards

Pallavi Ahuja

Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    To configure the data source credentials, click the gear button on the top-right hand of web view, then click "manage gateway".

     

     

    To configure the schedule refresh, click the ellipse and click Settings, then enable schedule refresh as below:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

5 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Anonymous ,

     

    You can definitely do it using Data Gateway. Download Data Gateway from PBI Service's Top right Download option button. Then configure it with Your data source and set the refresh time. With Pro license you can refresh automatically upto 8 times a day.

    You can refer the below URL for more deets on Data Gateway:

    https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

     

    Don't forget to hit THUMBS UP and mark it as a solution if it helps you! 

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    Anonymous ,

     

    Are you using import mode when connect to data source? If you are, please download a gateway here and install the gateway(on-premise or personal). Please refer to this doc to install and condigure the gateway on your server. Then you can publish your report and configure the data source credentails in power bi service. 

     

    Finally, you can configure schedule refresh in power bi service, please refer to this doc. If you need to share the report to your colleague, you can share the report with them(need a pro license), please refer to this doc.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      thank you your response but I am not able to find manage option for my report and hence, can’t set the credential for my datasource. Please let me know where can I find this option on power bi service (Web View).

       

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        6 years ago

        Anonymous ,

         

        To configure the data source credentials, click the gear button on the top-right hand of web view, then click "manage gateway".

         

         

        To configure the schedule refresh, click the ellipse and click Settings, then enable schedule refresh as below:

         

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.