Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III
Helper III

External table is not in the expected format --- while import .XLS file from sharepoint



Hello all,


I have power automate flow, it trigger on email received and saves attahments from ZIP file to sharepoint.

The file in zip file is in .xls. 



below image Advanced editor:-


below image is error.




option- 2 

I have tried to import excel file using dataflow in dataverse. then it gave below error.


DataSource.NotFound: 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:


after looking into many posts, I intalled access database engine 64 bit  and redistibutor of 2010. 

I tried to install 2016 version, but it didnot install as my MS office is32 bit (but my power BI is 64 bit) in local drive. 

but this solution didnot work. 

after looking further, I understood it should be installed in database source. how is it possible. 


Main goal .-  I need to import this .xls file in any of the power query(power bi desktop or dataflow in dataverse succesfully). 


Helper III
Helper III

Hi @BA_Pete ,

I have tried it as well. 

then in power query below error is shown.


In PA, I converted to .csv then the data is converted to html and html code is saved in csv file.


Below is my PA flow,

extracting the file from zip and saving this file as .xls





Super User
Super User

Hi @Krishna09 ,


You can update your PA Flow to convert the .xls file to .xlsx.

IIRC, I've done something similar in the past with flow steps like this:

Get File Metadata (<Identifier>)

Get File Content (<Identifier>)

Create File (as ~.xlsx) (<File Content>)

Delete File (<Identifier>)



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors