How to refresh all charts in one-click after importing a new local Excel worksheet?

[ryan1982]

I made a series of charts in Power BI with a local (in my hard drive) Excel file (.xlsx) with 2017 data. Now, I imported another Excel file in my hard drive with identical column names but everything is updated to 2018.

How can I refresh all charts and graphs to 2018 manually in the most effecient way?

(assume I have no access to the internet and cannot leverage OneDrive or any cloud thing)

Thank you for your help.

[v-cherch-msft · Accepted solution]

Hi @ryan1982

You may go to 'Advanced Editor' in query editor to change the path name of the file. Then close and apply. 

Regards,

Cherie

[ryan1982]

It works. Thanks a lot!