Forum Discussion
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 dashboard? I tried adding it through a shared link but that then failed when the file was replaced.
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
2 Replies
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
