Forum Discussion
AdministratorHow 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 until the previous day. Is there a way to do it?
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- VahidDM
Super User
Check these links, might be helpful:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-datahttps://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-local-drive
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
v-yanjiang-msftCommunity Support
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
