cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

How to make directory folder name dynamic ?

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

@Paulyeo11 , there is a blog on similar topic refer

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

@Paulyeo11 , there is a blog on similar topic refer

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Resident Rockstar
Resident Rockstar

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.

Highlighted

Hi Sit

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors