I have a report which i published from my Power BI desktop app. My Source data is stored on my local drive.
I have uploaded all my source data to my one drive and now i want to link my data source from local drive to One Drive in Power BI Services without hamperring the existing reports and Dashbords.
Please advice on this.
Thanks in advance.
Go to Solution.
I am assuming your source files are Excel files.
You will have to do two things:
= Excel.Workbook(Web.Contents("https://onedrive.live.com/download?resid=XXXXXXX&authkey=YYYYYYYYYYY&em=x&app=Excel"), null, true)
The appropriate credentials would be needed for either connection.
Does that help?
Proud to be a Datanaut!
Thank you so much Owen Auger.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.