Solved: Refresh data error

Anonymous · ‎07-31-2024

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 · ‎07-31-2024

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.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

View solution in original post

adudani · ‎07-31-2024

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.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash