Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

OLE DB or ODBC Error: [DataFormat.Error] External table is not in the expected format...

Hi All,   I have been using a pbix for monthly reporting. I add excel files on a monthly basis to a folder and combine them to generate the required figures and chart. Today I got the error message...
Need Help
Snoggi's avatar
Snoggi
New Member
7 years ago

Hi guys,

 

any solution to this problem already?

 

I got the same error and all included files are actually in the same format already.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Snoggi,

 

2 things helped me after all which I think you could try:

 

1) Check if you surely not have any hidden files in a folder which you pull in to your model as a datasource. Damaged xlsxes and any hidden files can mass up your dataflow. (I had those when I tried to save a file on our shared drive and had some network error in the meantime.) Easiest if you check in your query editor the list of files so you can easily spot whether there is something that does not make sense.

 

2) Delete the connections in your data model between your different tables, and re-make them. 

  • BSimonnet's avatar
    BSimonnet
    New Member
    7 years ago

    Hello,

     

    I have the same issue. re-install Office 365 but don't fix the PB. No hidden File. I recreate Excel fils. 

    Any ideas ?

    I am workind under the latest Windows 10 and the latest Office 365 on e VM Machine ( MAC) all softwares are up to date.

     

    Bruno