Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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]),
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]),
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?