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?
View solution in original post
Thank you so much Owen Auger.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.