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
4 years ago

Thanks I was looking to do that within Power Query!

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Yes, KNP has the correct answer. If you agree and it helps you Anonymous please mark it as the solution. As an additional bit of info, I'm not sure why Power Query in excel requires you to choose loading in Excel vs in Power Query. Power BI's Power Query is done in Power Query itself.

    But, in Excel's Power Query you can change the defaults of how it does work. When you install, all queries are loaded to a sheet. I disable that and load them as I need to on a case by case basis. It is in Power Query, in the Options dialog box.

     

  • KNP's avatar
    KNP
    Icon for Super User rankSuper User
    4 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?