Forum Discussion
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.
9 Replies
v-juanli-msftCommunity 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
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.
- Brunner_BI
Impactful Individual
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
Syndicate_AdminAdministrator
Hey there,
I have the same problem right now and am looking for an elegant solution. Did you by any chance find something good?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.
