I created .xlsx files using SAS on a Linux platform. The files are then FTP'd to Windows and read in Power BI. If the files are not opened in Excel and saved then Power BI cannot read the files and generates an error. Has anyone run into this issue and how did you resolve it? Thx! Here is the SAS code: proc export data=agt_detail2(drop=csr_id deptname phone_fcr_agent_end_time fox_fcr_exclude_reason) outfile="/vol3/data/userid/output/fcr/Excluded Calls &runmon. &crm_yr. v7.xlsx" dbms=xlsx replace;* label; sheet = "Agent Detail"; Here is the Power BI error: An error occurred in the ‘Transform File (2)’ query. DataFormat.Error: The document cannot be opened because there is an invalid part with an unexpected content type. [Part Uri=/xl/worksheets/sheet2.xml], [Content Type=application/xml], [Expected Content Type=application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml]. Details: [Binary]
... View more