Scheduled refresh for local Excel file with on-premise gateway

[jeanseb]

Hello,

I have created a Power BI dashboard, and my dataset is an Excel file which is located on my personal computer.
Is it possible to do a scheduled refresh for this?
I have tried, but when I try to add a dataset in my gateway, I have an error message, concerning windows id and password... how can I know the Windows id and password of my computer?
Thanks a lot,

Jean-Sebastien

[v-yuezhe-msft · Accepted solution]

Hi @jeanseb，

You are able to set schedule refresh for your dataset using on-premises gateway. Please find the Windows username and Password following my steps in this similar thread: https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-o....

Thanks,
Lydia Zhang