Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

How to automate data import

I have a database in sql server and to load the data to bi web I have to hit the import button, I would like that function to be done once a day at a specific time and thus know that I have the data ...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Syndicate_Admin ,

    If you publish the report to Power BI Service, you can use a gateway to configure scheduled refresh, which allows you to set a specific time of day to refresh the data source.

    Best Regards,
    Community Support Team _ kalyj

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

     

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Syndicate_Admin ,

If you publish the report to Power BI Service, you can use a gateway to configure scheduled refresh, which allows you to set a specific time of day to refresh the data source.

Best Regards,
Community Support Team _ kalyj

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