Forum Discussion

anandav's avatar
anandav
Skilled Sharer
5 years ago

Referencing a column value as file path to get Excel data file in Power Query

Hi,   I can give a network file path using Poawer BI parameters and use the parameter to get the Excel data file. Source = Excel.Workbook(File.Contents(Parameter1), null, true) I can save this re...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi anandav 

You may try the following steps:

 

1. Right click on the column which stores the data file path and select Add as New Query. This will generate the column into a new list. I call this list FilePath.

2. Create a parameter Parameter1, set Type > Text, Suggested Values > Query, Query > FilePath.

3. Modify the Source by using the parameter: Source = Excel.Workbook(File.Contents(Parameter1), null, true)

 

Kindly let me know if this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.