Forum Discussion

gvg's avatar
gvg
Post Prodigy
6 years ago
Solved

Dynamic source table name in Power Query

Hi, I have two data sources as tables in my query list: tableA and tableB. I want to build another query (myQuery) that dynamically takes either tableA or tableB as source. I know how to use paramet...
Show and Tell
  • avatorl's avatar
    avatorl
    6 years ago

    gvg

    Source = Expression.Evaluate("Table" & parameter, #shared)
avatorl's avatar
avatorl
Impactful Individual
6 years ago

gvg

Source = Expression.Evaluate("Table" & parameter, #shared)
  • psdhillon1's avatar
    psdhillon1
    Helper I
    5 years ago

    Hi

    Is this solution valid in PowerBi service as well. say providing a parameter in powerBi service & whenever new table added to database with same structure, one can select to see the dashboard KPI for new table. Actually, we are getting the survey results in new table & want to create an option with an self serviced solution where, someone just need to select the new table to see the results from this newly created survey. 

    I understand, we can do the same in desktop & can publish from there, but it involves manual efforts daily.