Forum Discussion
Refresh data from onedrive
Hi. You need to find the weburl or the excel file to replace the "C\\" and change the method File.Contents to Web.Content. The following post explains it:
https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedriveI hope that helps,
jennratten Sorry, i'm not fully understanding it (yet). In my PBIX file I have two tables that come from Excel. Currently for both those tables when I go into the query editor the source is:
= Excel.Workbook(File.Contents("C:\Users\name\OneDrive - company.com\PowerBI\Report V3.xlsx"), null, true)
How do I need to adjust this?
Hi. You need to find the weburl or the excel file to replace the "C\\" and change the method File.Contents to Web.Content. The following post explains it:
https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedrive
I hope that helps,
Thank you both for your help! with the guide from the website I was able to get it working! Thanks
Wonderful!
