Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Get data from ODS files (OpenOffice/StarOffice spreadsheet)

I tried to Get data from folder with ODS files ( OpenOffice/StarOffice spreadsheets that are easily opened by Excel). However PowerBI does not recognize this format, which frankly speaking is strange...
Need Help
Brunner_BI's avatar
Brunner_BI
Impactful Individual
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Rebecca6634 , could you please create another post with your question?  Please include the code that you have used in that post.
    Many thanks

    Daryl