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
sb4pbi's avatar
sb4pbi
New Member
2 years ago

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.