Forum Discussion
Solved
Replaced Excel document in Sharepoint
We have an Excel file placed into a Sharepoint folder every week, this file is over written but still is in the same spot with the same name. Is there a way to import that data into a Power BI da...
twrigglesworth you have to use the filepath - I've written a blog about this exact topic it was so tricky to find info on it: https://excelwithallison.blogspot.com/2022/01/get-data-from-sharepoint-files-into.html
twrigglesworth you have to use the filepath - I've written a blog about this exact topic it was so tricky to find info on it: https://excelwithallison.blogspot.com/2022/01/get-data-from-sharepoint-files-into.html
Hi Alison,
A true hero ❤️ I tried that before but it have me error messages. Followed the blog exactly and that worked.
Thank you so much