Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am connecting to a report folder containing multiple Excel workbooks of the same layout. I have a user in China who uses WPS Office (WPS spreadsheet is said to be compatibale with Excel) Excel does not have a problem with the file - but Power BI will not recognize it as an Excel file. All the workbooks in the folder process fine if I remove the WPS/Excel workbook. If I re-create the file (copy/paste all values) into an Excel file, the workbook is then recognized by Power BI. I suspect there is something in the XML file structure that Power does not "like".
How can I work around this problem - user in China is a third party organization - so asking them to "upgrade" is not an option. I need to receive and process these files daily.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |