Forum Discussion

Taher28's avatar
Taher28
Frequent Visitor
2 years ago

Encountering an error while ingesting a .xlsb file from SharePoint using Data Flow Gen2

Encountering an error while ingesting a .xlsb file from SharePoint using Data Flow Gen2 and loading the data into a Lakehouse.

I have data in a .xlsb file, and I want to ingest this data into a Lakehouse using Data Flow Gen2. However, I am encountering an error during the ingestion process.
Error details:
"An exception occurred: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=. (Session ID:)"

 

Any help is appreciated. Thank you.

 

Dataflow
Need Help

1 Reply

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Taher28 

    You are using the wrong connector if you are trying to connect to Sharepoint. You need to use Sharepoint Folder connector instead.