Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I use Apache POI to generate xlsx files. Recently I upgraded from Apache POI 4 to Apache POI 5 and my excel files started failing their upload to my workspace (https://app.powerbi.com/).
My investigation led me to generate roughly the same content using Apache POI 4 and Apache POI 5 and narrowed down the issue to the applyAlignment="true" attribute in the excel file's "xl/styles.xml" file. This attribute was added to Apache POI 5 as a bug fix (https://bz.apache.org/bugzilla/show_bug.cgi?id=64494) and seems to be causing an error when uploading to my Power BI workspace.
I removed all instances of the attribute from the styles.xml file, and I was able to successfully upload the file to my Power BI workspace.
Interestingly, the same xlsx file can be opened just fine in other Microsoft products, such as Excel.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @stitches
So your problem is caused by upgrading the version of Apache POI, is it ?If you restore Apache POI to 4.0, does the problem still exist?
Best Regards,
Community Support Team _ Ailsa Tao