Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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, as MS Excel can easily read these files.

 

Could you please advise why PowerBI does not recognize this format?

Are there any plans for PBI to recognize ODS files?

 

I would like to avoid step with converting ODS to excel.

 

ODS.png

9 REPLIES 9
sb4pbi
New Member

Hi, 

I was also facing the same issue while trying to import the Libre Office (excel) file to Power BI Desktop. 

 

I was able to resolve issue by saving Libre office (excel) file as "Save as Excel". 

and then try to import it. 

 

Not sure about ODS. See if it helps. 

 

Thanks,

Saurabh B. 

Syndicate_Admin
Administrator
Administrator

Hey there,
I have the same problem right now and am looking for an elegant solution. Did you by any chance find something good?

v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

There is a workaround: convert ods file to excel file using online tool, then connect to excel files with Power BI.

 

Best Regards

Maggie 

Anonymous
Not applicable

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.

 

Here is a better way without any third party tools

 

https://en.brunner.bi/post/how-to-open-ods-files-in-power-bi-power-query

 

Thanks!

How did you find this?

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!

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors