SOLVED

How to pass search Parameter for Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-813284%22%20slang%3D%22en-US%22%3EHow%20to%20pass%20search%20Parameter%20for%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813284%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EHow%20do%20I%20force%20the%20query%20to%20prompt%20for%20a%20parameter%20value%20to%20use%20to%20filter%20result%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127654i762FDA67B1E9F2EB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22MS-Query.JPG%22%20title%3D%22MS-Query.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-813284%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813340%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20pass%20search%20Parameter%20for%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395269%22%20target%3D%22_blank%22%3E%40c2crane%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can't%20prompt%20parameter%20to%20take%20it%20from%20input%20window%20field%2C%20but%20you%20could%20use%20some%20cell%20value%20in%20your%20sheet%20as%20parameter%20passing%20it%20to%20query.%20See%2C%20for%20example%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.excelguru.ca%2Fblog%2F2018%2F05%2F30%2Fcreating-dynamic-parameters-in-power-query%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excelguru.ca%2Fblog%2F2018%2F05%2F30%2Fcreating-dynamic-parameters-in-power-query%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815369%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20pass%20search%20Parameter%20for%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815369%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20pointing%20me%20in%20the%20right%20direction%20to%20solve%20issue!%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
 

How do I force the query to prompt for a parameter value to use to filter result?

MS-Query.JPG

2 Replies
Highlighted
Solution

@c2crane 

You can't prompt parameter to take it from input window field, but you could use some cell value in your sheet as parameter passing it to query. See, for example, https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/

Highlighted

Thanks for pointing me in the right direction to solve issue! @Sergei Baklan