DataFormat.Error: External table Troubleshooting help RRS feed

  • Question

  • Images of the error are below. I receive a [DataFormat.Error] External table is not in the expected format error while trying to load my query. My query looks to a folder that contains multiple folders with multiple excel files(300+) all in the same formatting, or supposed to be. When I try to load/refresh the query it does not tell me where the table is located, only the error box pops up. I have to try and scroll through multiple rows to find the error in the edit screen so that it will point me towards the file that is the issue. My question is how can I find this information much easier? This will probably happen again.

    Much Thanks,

    Tuesday, September 5, 2017 7:11 PM