moving local files to One Drive for Business

[jagostinhoCT]

Hello,

How can I relink files from One Drive for Business in Power BI Desktop to replace existing Sources?

These files were originally on a local drive and I would like not to loose work done in Desktop.

Many thanks

Joaquim

[Greg_Deckler · Accepted solution]

You can replace your Source line in your M code "View | Advanced Editor" with something like:

Source = Csv.Document(Web.Contents("https://[tenant]-my.sharepoint.com/personal/[user]/Documents/State, Zip Code and Value.csv"),[Delimiter=",", Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.None]),

[jagostinhoCT]

thank you @Greg_Deckler.

I am keeping my username and it works perfectly.

Will it pose any problems, however, if another user is using the pbix file?