Parameter value from excel

[sanjay009]

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?

[Icey · Accepted solution]

Hi @sanjay009 ,

Please refer to these posts:

Data Download from Website and connection with Power BI;

Combining Multiple 'Web' Data Sources.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Icey · Accepted solution]

Please refer to these posts:

Data Download from Website and connection with Power BI;

Combining Multiple 'Web' Data Sources.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FrankAT]

Hi @sanjay009 

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)

[sanjay009]

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]

Hi @sanjay009 

Can it help you

Then go to source