Dynamic SQL queries with Power Query (Can be used for Excel and Power BI) - WHERE Conditions

Dynamic WHERE conditions for your SQL queries with Power Query (Can be used for Excel and Power BI)

[bishop]

Outstanding, very helpful. Thank you. I made some modifications to create a dynamic " IN " clause with comma separators. I even created multiple lists of parameters or even single parameters. It works wonders. Now all the accountants in my company are asking me for the same powerquery tools to perform recurrent checks. That will save them a lot of precious time.

[polvacf]

What a powerful and simple solution you 've given us!!. I used this in order to get a dynamic WHERE statement based on the values of an Excel column that a used as source together with a MySQL DB in a PBI Dashboard. Thx a lot!!

[kdhlhjz]

very nice! I will needing this to implement in one of my PBI report

[MSOfficeQuickTips]

THANK YOU!! I've been trying to figure this out for a while and this new skill will come in VERY handy!

[lfpinzonb]

An easy and powerful method to use dynamics parameters! Congrats!

[Adam_Pagan]

Thank you so much for this video, one of the most useful tiips I have seen yet for POWRBI. Subbed!

[rubengao]

I've been looking for a solution for updating SQL statement without having to manually update the script itself! This is seriously, freaking AWESOME!

Thank you! 🙏👍

[chrise]

Thank you so much! This video was essential for me to find out how to do this. You’re brilliant!

[tiste_sg]

Thanks for the tip! Loved the video, straight to the point!

[raymondjurado]

Have you utilized Text.Combine to create multiple NOT conditions through the same concatenation of the custom column? How is the performance?

[Kajan]

Thank you so much for this. I was struggling with the privacy error for hours.

[sergio_molinari]

A perfect Solution 4 my query's!
U r GREAT!

[bharanidharans]

Great stuff... just what I was looking for...

Awesome

[ccarduz]

Graciela, thank you very much for your help. I've been looking for this solution for quite some time.

[esk]

Thank you, this is a great skill to have.

[matthewbrierley]

This is fantastic. Really is. Nice one!

[mkovcin]

ЊХ <del><del> WHERE -- поздрав

[swativish]

Hi does this work when we do schedule refresh for Power Bi. I am unable to refresh this on the service

[areebahmedkhan]

Im getting error we cannot apply operator & to types text and Table

[lisanordling]

Is it possible to have the WHERE clause after the GROUP BY, or can you insert the variable in-between the FROM and the GROUP BY? Any help appreciated!