When attempting to import an excel file into a Roambi View, the follow error message appears:
"Error. The file could not be opened. The file format is not supported, the file is corrupted or the file is password protected."
This may occur when exporting an Excel file from an SSRS report and immediately importing into Roambi Business.
- SAP Roambi Cloud
- SSRS 2012
The excel file may be locked or protected. When exporting an excel from an SSRS report, the file may be locked initially, which will prevent SAP Roambi from reading it.
Open the Excel file again and ensure the file is not locked when it is saved.
KBA , BI-ROM-CLD-PUB-BI , Roambi Cloud publishing clients – BI, Cognos & SSR , Problem