SAP Knowledge Base Article - Public

2326631 - "Error. The file could not be opened. The file format is not supported, the file is corrupted or the file is password protected."

Symptom

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.

Import Data.png

Environment

  • SAP Roambi Cloud
  • SSRS 2012
  • Excel

Cause

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.

Resolution

Open the Excel file again and ensure the file is not locked when it is saved.

Keywords

KBA , BI-ROM-CLD-PUB-BI , Roambi Cloud publishing clients – BI, Cognos & SSR , Problem

Product

SAP Roambi Cloud all versions