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.
Hi!
I have a list of users and their offices. I need to split these out and load the list of users from each individual office into seperate Excel sheets. I'm afraid my PQ expertise has hit the buffers!
The list is like this:
Office User
Brighton Fred Blogs
Brighton Bill Smith
Newcastle William Shakespeare
Manchester Eric Morecambe
Manchester Ernie Wise
and so on.....
I want a Excel tab for each of the offices with a list of users and a total number of users for that Office
Can anybody point me in the right direction please?
Thanks.
Ian
if you need the automation I'd suggest recreating your PowerBI transformations in PowerQuery (or Get&Transform, in the new ones) and automate with VBA
if there are not that many offices you can jut use PowerQuery and create the sheets manually, they will all refresh when you press Refresh All
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.