How to make directory folder name dynamic ?

[Paulyeo11]

Hi All

now my colleague and me share one PBI file at one drive. 

it there a way to make folder path name dynamic in M code ?

So that i don't need to have 2 set of raw data folder for him and myself .

Paul Yeo

[PhilipTreacy]

Hi @Paulyeo11 

Further reading if you are interested

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters 
https://support.microsoft.com/en-us/office/create-a-parameter-query-c67d9af7-c8a0-4bf7-937c-087cb25f...

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Paulyeo11]

Hi Sit

thank you very much for sharing . The TOP link very useful

[amitchandak · Accepted solution]

@Paulyeo11 , there is a blog on similar topic refer

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters