Adding parameter based on username to data source

[qxphm]

Dear All,

We started using Onedrive in my company which ended up having our own username in data source's paths.

Therefore, whoever would like to refresh the Power BI destop, needs to change the source first to the new path with his/her own username. Something like:

C:\Users\ username \OneDrive\Desktop

Is there any way to automate it? For example to create a parameter that will automatically find the name of the current user and adjust it automatically in the data source? In VBA there's a function Environ() that is really helpful, not sure if something similar exists in Power BI.

Thank you in advance.

[Idrissshatila]

Hello @qxphm ,

Check this video it will help your with your case

https://www.youtube.com/watch?v=XIq5vN5oPf8&t=89s

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin