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 ...
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.

     

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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

         

        Thank you for your reply. I installed and set up the gateway and scheduled daily refresh of the dataset. The problem in my office internet is proxy now. So I went through the below doc link and configured the proxy settings accordingly. But the gateway is not working, it always fails at the time of scheduled refresh.

        https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-Proxy