Refresh data error

[Anonymous]

Hi all, I hope you can help me with this problem. 

I am working with an Excel document that is located in the share point of the company. I modified the data from the excel file, and I need to refresh it on PowerBI, but I got this message:

Could not find a part of the path 'C:\Users\MA2\XXX\Innovation\Activities\Roadmap & Status\Roadmap_pBi.xlsx. 

Thank you in advance for your help. 

[adudani · Accepted solution]

hi @Anonymous ,

if the excel path is located in Sharepoint, typically the sharepoint.files / sharepoint.content("URL/URI") is used.

For more information, refer to Connect Excel / CSV files from SharePoint to Excel or Power BI (youtube.com) 
at the timestamp 4:22 the formula used to connect is displayed. Once the navigation is completed and the data in the file is extracted, you can perform the transformations steps applied to the excel document.