One Drive Data Source File Paths

[nsewall]

Hello,

I'm trying to use a data source that exists within our company's one drive. The issue I'm having is that the file paths for one drive are different depending on who's account you're logged into so for example my file path would looks something like:

C:\Users\MyUsername\OurOneDriveFolder\etc

whereas my bosses' file path would look something like:

C:\Users\MyBossesUsername\OurOneDriveFolder\etc

This means in order for either of us to refresh the data we need to go in and manually update the file path if we weren't the last one to do so. I was looking for a way this could be done automatically.

I noticed that in the advanced options for Data Source Settings you can actually break up the file paths and use parameters for portions of them so I thought I could do something like 

C:\Users\

Parameter containing the username function

\OurOneDriveFolder\etc

But because the username function is not supported by calculated columns I couldn't figure out how to actually create a parameter for it since it only accepts list queries. Does anyone know a way I could create a parameter with the username function or another way to accomplish this?

Thank you!

[Greg_Deckler · Accepted solution]

@nsewall Well, you could create a text parameter that must be updated manually. There is no concept of "environment variables" in M that I am aware of, so you can't use things like %username% for example.

[samdthompson · Accepted solution]

Yeah, this is a problem I found a while ago:

https://www.excelguru.ca/forums/showthread.php?10756-Acess-data-in-shared-onedrive-file&highlight=on... 

only solution would be to host it on your one drive and share it with someone who edits it on your instance.

[nsewall]

Good to know, thanks!

[Greg_Deckler · Accepted solution]

@nsewall Well, you could create a text parameter that must be updated manually. There is no concept of "environment variables" in M that I am aware of, so you can't use things like %username% for example.

[nsewall]

Good to know, thanks! I ended up just moving the file to our company's sharepoint.