Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data Refresh from locally stored excel files

Hi,   I have built a Power BI Desktop Data model using Excel files stored in my local machine (Not sharepoint or onedrive). The data in excel is updated once every day.   Ideally, I would want to...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

It is a simple way, You need to install a gateway, then set up the gateway for the dataset

https://docs.microsoft.com/en-us/power-bi/service-gateway-getting-started

https://docs.microsoft.com/en-us/power-bi/service-gateway-install

https://docs.microsoft.com/en-us/power-bi/service-gateway-manage

Now configuring scheduled refresh for it.

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

 

 

Best Regards,

Lin