Can we specify in Power Query which local worksheet to load the data?

Hi Anonymous ,

Put all the worksheets to a folder,then connect the folder to power bi.

For details,pls check below:

https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder

In query editor,you could select which worksheet to load,once you have updated a new one,you could also remove the old one.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!