Forum Discussion
Helper VError when extracting excel files from SharePoint site
Hi all,
I get below error when I try to import some excel files from SharePoint folder.
can you please assist
amalrio is it a xlsx or xls file? Seems like it is xls file and if that is the case you need to install oledb driver as given in the error message.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
4 Replies
- parry2k
Super User
amalrio is it a xlsx or xls file? Seems like it is xls file and if that is the case you need to install oledb driver as given in the error message.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- amitchandak
amalrio , How are you importing Are you following this way - Same for share point and one drive -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Or install oledb driver -https://www.microsoft.com/en-in/download/details.aspx?id=13255
- parry2k
amalrio check your Windows OS is 32 bit or 64 bit and install accordingly.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
