Home

Import data from MYSQL db to excel and use excel cell as a parameter in query

%3CLINGO-SUB%20id%3D%22lingo-sub-682892%22%20slang%3D%22en-US%22%3EImport%20data%20from%20MYSQL%20db%20to%20excel%20and%20use%20excel%20cell%20as%20a%20parameter%20in%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682892%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20successfully%20connected%20to%20MYSQL%20db%20from%20data%20tab%20%26gt%3B%20Get%20data%26gt%3B%20from%20database%20%26gt%3B%20from%20mysql%20database.%20connection%20is%20successful%20and%20I%20am%20able%20to%20see%20data%20in%20Excel.%3C%2FP%3E%3CP%3ENow%20I%20want%20to%20use%20a%20date%20present%20in%20Excel%20cell%20in%20query%20where%20clause.%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20me%20understand%20how%20to%20use%2Fconfigure%20Parameter%20for%20MYSQL%20queries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20I%20tried%20opening%20Query%20properties%20%26gt%3B%20Definition%20tab%20but%20Parameter%20button%20is%20disable.%26nbsp%3B%20how%20to%20enable%20this%20or%20configure%20parameter%20in%20Power%20query%20editor.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-682892%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerEditor%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686245%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20MYSQL%20db%20to%20excel%20and%20use%20excel%20cell%20as%20a%20parameter%20in%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686245%22%20slang%3D%22en-US%22%3ESee%3A%20%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F3091908%2Fhow-to-add-parameters-to-an-external-data-query-in-excel-which-cant-be-displaye%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F3091908%2Fhow-to-add-parameters-to-an-external-data-query-in-excel-which-cant-be-displaye%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686298%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20MYSQL%20db%20to%20excel%20and%20use%20excel%20cell%20as%20a%20parameter%20in%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686298%22%20slang%3D%22en-US%22%3E%3CP%3ET%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Bfor%20suggesting%20the%20link%2C%20I%20am%20aware%20of%20this%20feature%20but%20this%20feature%20works%20only%20with%20MS%20SQL%20server%20and%20not%20with%20MySQL%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20unable%20to%20add%20Parameters%20for%20MYSQL%20queries%20only%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686308%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20MYSQL%20db%20to%20excel%20and%20use%20excel%20cell%20as%20a%20parameter%20in%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686308%22%20slang%3D%22en-US%22%3EOdd%20as%20this%20should%20work%20with%20any%20ODBC%20compliant%20database%20system.%3C%2FLINGO-BODY%3E
Pushkarjo
New Contributor

I have successfully connected to MYSQL db from data tab > Get data> from database > from mysql database. connection is successful and I am able to see data in Excel.

Now I want to use a date present in Excel cell in query where clause. 

Help me understand how to use/configure Parameter for MYSQL queries.

 

Note: I tried opening Query properties > Definition tab but Parameter button is disable.  how to enable this or configure parameter in Power query editor.

3 Replies

T@Jan Karel Pieterse for suggesting the link, I am aware of this feature but this feature works only with MS SQL server and not with MySQL,

 

I am unable to add Parameters for MYSQL queries only .

Odd as this should work with any ODBC compliant database system.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies