Showing results for 
Search instead for 
Did you mean: 
ianw1000 Regular Visitor
Regular Visitor

Creating Excel sheets from PQ data


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?



Stachu Super Contributor
Super Contributor

Re: Creating Excel sheets from PQ data

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,897)