Forum Discussion
Get data from ODS files (OpenOffice/StarOffice spreadsheet)
Hi Maggie,
Thanks, but this actually does not answer my question and to be honest I would not recommend the solution you proposed.
Sharing any company reports online bears great risk of data leak. Secondy, using this tool takes longer than saving .ods file as .xlsx in Excel. Or saving .ods file as .xls.
I would really appreciate if anyone could share information whether there are plans for PBI to recognize .ods files in the future.
Impactful IndividualHere is a better way without any third party tools
https://en.brunner.bi/post/how-to-open-ods-files-in-power-bi-power-query
Syndicate_AdminAdministrator
Thanks!
How did you find this?
- Brunner_BI
We found somewhere that .ods is similar to zip and there was this M code (as outlined in the blog post) for unzipping files in Power Query. We gave it a try and ended up with our xml file and then after some transformations were able to load the table we were expecting.
It also refreshes in the service, our public "covid report" is using this data for the demographic distribution in Austria.
Our source file is hosted here.
Hi Brunner_BI
I need to connect to this file Live tables on homelessness - GOV.UK (www.gov.uk). Please could you advise how to do this with your code, I can't seem to get it to work.
Thank you!
