Power BI / query, select columns dynamically RRS feed

  • Question

  • I need to extract a table with selecting columns in power query dynamically.

    For example,

    In query 1, I have Columns ("ID", "column1", "column2","column3","column4", "column5", "column6")

    In query 2, this is a list from another source that contains a list of column labels i need, eg. ("column1", "column5", "column6") <--- String

    So i want to have columns ("ID", "column1", "column5", "column6") in my final table.

    Any way to do this?

    Thank you

    Tuesday, July 30, 2019 7:56 PM