Source as a file on OneDrive

[stribor45]

I was wondering if I can somehow make my excel file on OneDrive curently set up like below more flexibile

    Source = Excel.Workbook(File.Contents("C:\Users\myusername\OneDrive\Names.xlsx"), null, true),
    sheet1_Sheet = Source{[Item="sheet1",Kind="Sheet"]}[Data],

 Above is a problem if I use different computer to open my PBI as my OneDrive is mapped differently on dofferent computer.

Also service has issue refreshing my report with "local files" set up like this

[v-sdhruv]

Hi @stribor45 ,
Just wanted to check if you had the opportunity to review the solution provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[danextian · Accepted solution]

hi @stribor45 

​To access on-premises or local data sources in Power BI, you must install a data gateway on a machine that has continuous access to the data file and remains online. This gateway facilitates secure data transfer between your local environment and the Power BI service.

However, if your data resides in OneDrive for Business or SharePoint, you can bypass the need for a data gateway by using the direct URL of the file and connecting through Power BI Desktop's Web connector.

Source = Excel.Workbook(Web.Contents("https://myorg.sharepoint.com/sites/sitename/folderpath/filename.xlsx"), 
null, true),
sheet1_Sheet = Source{[Item="sheet1",Kind="Sheet"]}[Data],