How to automate data import

[Syndicate_Admin]

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?

[v-yanjiang-msft · Accepted solution]

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.

[VahidDM]

Hi @Syndicate_Admin 

Check these links, might be helpful:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

https://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!! 

LinkedIn | Twitter | Blog | YouTube