- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Bug - Unable to upload xlsx file to Power BI workspace due to applyAlignment attribute
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.
-
NikNithiy
on: URGENT!! Paginated Report not loading on Mozilla F...
- duarte on: Unable to sort months in PowerBI
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on: Fix the Date function in DAX
-
Stinkys
on: Cannot login to community site
-
reubwork
on: May 25 update for Snowflake Connector v2 has broke...
-
dmkblesser
on: Unable to open existing PBIP files
- New 8,024
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,231 -
Data Modeling
4,130 -
Dashboards
4,113 -
Report Server
2,114 -
Gateways
2,112 -
APIS and Embedding
1,965 -
Custom Visuals
1,789 -
Content Packs
523 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Power BI Desktop
1 -
Tips and Tricks
1