refresh data

[Anonymous]

Is it possible to refresh data from for example excel-files automatically with Power BI Desktop?

[v-yingjl · Accepted solution]

Hi @Anonymous ,

I’m afraid not. Power bi desktop is a local application for designers. When you connect to an excel file, the connect mode is Import, you need to refresh manually after you changed the data source. Even if the connect mode is Direct Query, you can just use Page Auto refresh in power bi desktop. If you want to refresh data automatically, you need to publish to power bi service to configure scheduled refresh.

For further information about refresh, you can refer the following Microsoft document and case that could help you:

1. https://community.powerbi.com/t5/Desktop/How-to-Auto-refresh-data-in-Power-BI-Desktop-from-SharePoint/td-p/20480
2. https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Best Regards,

Yingjie Li

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

[amitchandak]

Refer:

https://community.powerbi.com/t5/Desktop/Incremental-data-load-from-Excel/td-p/140728

https://www.poweredsolutions.co/2020/01/19/incremental-refresh-for-files-in-a-folder-or-sharepoint-p...

[lkalawski]

Harmen

You did not quite specify the question.
You want to store data in Excel and connect it with Power BI. And then change the data in Excel and automatically refresh the report in Power BI. Right?

_________

If I helped, please accept the solution and give kudos! 😀