Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sanjay009
Helper III
Helper III

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?

 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
Icey
Community Support
Community Support

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.

FrankAT
Community Champion
Community Champion

Hi @sanjay009 

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

 

15-09-_2020_22-28-57.png

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

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
Community Champion
Community Champion

Hi @sanjay009 

Can it help you

aj1973_0-1600201567625.png

Then go to source

aj1973_0-1600201676821.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.