Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

Hello   Can we specify in Power Query which local worksheet to load the data? And also to overwrite and delete old rows?   Thanks!
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks I was looking to do that within Power Query!

KNP's avatar
KNP
Icon for Super User rankSuper User
5 years ago

Technically, the answer to your questions are, no and it overwrites and deletes by default.

I'm struggling to understand the use case here. Once you set the load location to the worksheet you want, it persists. Why does it need to be done in Power Query?