Forum Discussion
Using Excel Column for Dynamic SQL Power Query
I am having difficulty using an existing excel column to create a dynamic SQL power query. In the below link there are two example to make this work. https://techcommunity.microsoft.com/t5/BI-and...
JonathanLewis , by the way, if your parameters are in supporting table within Excel, let say tblParam with the column Options, you may query your table, change Options to text type if necessary, and
MyParameters = Text.Combine(tblParam[Options], ",")