Forum Discussion
Power query question
I have a project for 1500 timesheets 2 times a month. we download a spreadsheet from our payroll company that contains all 1500 employees time entries and shift notes in a single xml file. wha...
It is possible but not efficient or suitable. I wouldn't recommend using Power Query to achieve this. I would try to do it in Python (don't worry you don't need to be an expert in coding to do it, there are many libraries, trainings and pre-built templates do to what you want to do) or through Power Automate.