Forum Discussion

echoniner's avatar
echoniner
New Member
7 years ago
Solved

Function to get dynamic file names not working with RelativePath

Hi!   So, I have a query that's working with a function. Here it is:   (file as text) => let Source = Json.Document(File.Contents("E:\FTP\Client\Data\"&(file))),   That's working fine, but it...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi echoniner 

If you import data into Power BI, It should support for refresh in Power BI Service.

Edit parameter settings in the Power BI service

 

You could create a query parameter under Edit queries->Home->Manage parameter->New Parameter

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4

Then use this parameter ((file parameter) in the Source code.

 

Reference:

https://gqbi.wordpress.com/2016/11/23/power-bi-using-parameters-for-flat-file-csv-excel-sources/

https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/

 

As for use a Relative Path, I hope this link will be helpful.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I was able to get this working.

 

Thanks again for your response, v-juanli-msft 

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    Since it is sloved, could you kindly share the solution to more people here and accept it as a solution to close this case?

     

    Best Regards

    Maggie