Read data from column in Sheet

Question

Dear friends, I have&nbsp; a question about pass a column in a sheet as parameter (that may change in the number of elements on the same column from one time to other)&nbsp;&nbsp;I have this power query in Excel:&nbsp;&nbsp;= Odbc.Query("dsn=MIDB", "SELECT &nbsp; &nbsp; &nbsp; &nbsp;I3_NUMED AS MEDIDOR, I3_STATUS AS STATUS_MED#(lf)FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CATAL3#(lf)WHERE &nbsp; &nbsp; &nbsp; &nbsp;(I3_NUMED IN ( 'P521Y8 ', '523DNE ', '4V97T5 '))")&nbsp;And it returns all data without problem to an excel Sheet1 all the info requested. I can change manually the parameters and again I got the result in the sheet without any problem:&nbsp;Now, in the same book in Sheet2, I wrote in the column A,&nbsp; a new set of parameters that I wish to use as new parameters, but, I dont know how to "link" to the power query to let know that those elements are the new parameters for my query:&nbsp;&nbsp;I wish to understand how to do this the mos elementary form. And then I will continue improving the query from myself.Any help would be appreciated.Thank very much.&nbsp;&nbsp;

dax · Accepted Answer

Hi&nbsp;epayen&nbsp;,&nbsp;
Did you mean that you want to use another sheet as parameter values, right? If so, you could refer to&nbsp;Pass-ParametertoPowerbI&nbsp; for details. Or you also could refer to below&nbsp;How to handle SSRS multi-value parameter filtering in SQL Server Parallel Data Warehouse&nbsp;, then combine sheet's values into a string, and filter with this string.
Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

Forum Discussion

Read data from column in Sheet

2 Replies

Related content

Google sheets

Power BI read aloud

Gen2 dataflow read only mode issue

Add custom column with sheet name

Reading through Columns