PowerQuery – Turning My Frown Upside Down

Microsoft has started to include this very handy button in all of their new Excel add-ins.

1-sending-feedback

It is for people to send feedback to the Microsoft developers about problems they are having, problems they are solving or if they are generally happy with the product.

This week I was using PowerQuery to see if I could use it to query Active Directory (AD) and list all the members of a specific AD Group (more on this in a future post). However, whilst I was able to get PowerQuery to list the members of some AD groups it wouldn’t list them for the groups I was actually interested in.

2-powerquery-error

I reached out to a friend of mine Niko Neugebauer (twitter | web), he took a look at what I had done and couldn’t see anything obviously wrong with it and so he asked me “did you try sending a frown feedback to the dev team?”. Until he actually suggested that it didn’t cross my mind.

I promptly clicked the “Send a frown”, this brought up an email already typed out, with a screenshot of what I was doing and the formulas I had written, I added some more detail and sent it off.

I also posted on the PowerQuery TechNet forum.

The next day I received a response to my email from the PowerQuery team asking me some questions, at the same time someone who works on the PowerQuery team reached out to me on Twitter and there were two responses waiting for me on the forum, one of which was the solution.

My frown was turned upside down (to a smile), and I learnt a lesson – it’s ok to send a frown from time to time.

The answer was to turn on Fast Combine, but more on that another time. Thanks to all of you who helped me out 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s