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.
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.
what I need to do is run a query to pull just a single employees time entries and shift note into a new excel file. I need to do this for all 1500 employees.
so source file is a master timesheet excel file and I need 1500 individual excel spreadsheets that just show each employee time entires and shift notes.
is this possible with power query. I have been watching a lot of power query videos and i cannot find a single one that says it is possible.
Thank you in advance for any help you can provide
In the formula bar, type:
= let Rows=Table.RowCount(NameOfPriorStep) in Table.Split(PriorStepName, Rows)
--Nate
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.
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.