Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Parameter value from excel

I  have a Parameters table with parameter name and value as below

 

Parameter name   Value

filename               september_month_report.xlsx

filename2               september_month_report V2.1.xlsx

 

I want to use the filename in the parameter in power bi query, How can i do it?

 

Need Help
Show and Tell

4 Replies

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi Anonymous 

    you can do it on tabe Home >  button Manage Parameters like this:

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      if I add to the Parameter list. I manually has to select the filename from list. Looks like i missed excel in the earlier question.

      Actually, I have excel parameter table. i want to get the filename from the excel table to Power query.

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Hi Anonymous 

    Can it help you

    Then go to source