Forum Discussion
Solved
Read data from column in Sheet
Dear friends, I have 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) I have this power query in Exce...
Hi epayen ,
Did you mean that you want to use another sheet as parameter values, right? If so, you could refer to Pass-ParametertoPowerbI for details. Or you also could refer to below How to handle SSRS multi-value parameter filtering in SQL Server Parallel Data Warehouse , then combine sheet's values into a string, and filter with this string.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490