Steve James on 05 Jun 2023 10:38:01
ODS file structures are becoming more and more common.
Excel recognises the ODS format but Power Query doesn't appear to be able to read ODS files.
I've read that they can be read using some native M functions but Power Query should be able to handle ODS files as it does other file based data.
Thanks