Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
Can we specify in Power Query which local worksheet to load the data? And also to overwrite and delete old rows?
Thanks!
Thanks I was looking to do that within Power Query!
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?
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Yes, @KNP has the correct answer. If you agree and it helps you @UsePowerBI 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@UsePowerBI - I've just re-read your question and I think I understand now what you're saying. I don't think the answer that has been marked as a solution is correct.
If you right click on your query and choose 'Load To...'
In the next dialogue box choose 'Table' and 'Existing worksheet'
This will let you specify the location and click load.
By default data will be replaced by the query but there are also some additional settings if you go to the table properties.
Example workbook attached.
If this answers your question, let me know and I'll make sure it gets marked as the solution.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @UsePowerBI ,
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!
Yes you can do this.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.