Problem to solve: importing many files into Power BI where some are not complete and trigger an ODBC error.
While importing thousands of JSON files I bumped into the situation where some of the files weren’t following the structure and thus caused an error and the import process to stop. The files were supposed to have some general and customer information about an order and order lines structured under “lines”.