Forum Discussion

NJS0303's avatar
NJS0303
Frequent Visitor
6 years ago

Columns missing from imported Excel data

Hello,   Looking for some assistance with an issue I'm having with imported Excel data.   I've got several reports linked to approximately a dozen different excel sheets and without any obvious c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hey There,

 

I know this is an older post/issue but i've recently run into the same problem as my company has upgraded our SAP BO program to:

SAP BusinessObjects BI Platform 4.3 Support Pack 3 Patch 1 Version : 14.3.3.4496.1

 

I've found that adding an additional column on the right-most side of your SAP BO report seems to resolve the issue (essentially, the read error is happening on the right-most "TEST" column, but no issues with the rest of my data now)

 

This resolution is definitely not as intuitive or technically sound as most of the previous answers but, it has worked for me 😁

ShankarS's avatar
ShankarS
Frequent Visitor
3 years ago

 

Anonymous wrote:

Hey There,

 

I know this is an older post/issue but i've recently run into the same problem as my company has upgraded our SAP BO program to:

SAP BusinessObjects BI Platform 4.3 Support Pack 3 Patch 1 Version : 14.3.3.4496.1

 

I've found that adding an additional column on the right-most side of your SAP BO report seems to resolve the issue (essentially, the read error is happening on the right-most "TEST" column, but no issues with the rest of my data now)

 

This resolution is definitely not as intuitive or technically sound as most of the previous answers but, it has worked for me 😁

 

 

Hi - Has this been already raised with Power-BI team for fixing the Connector OR with the SAP team if its a problem with the BO patch issue? Were you able to find a permanent resolution to this?

 

We just updated our environment to this version and face the same issue - so wanted to confirm if we can piggy back on the issue you may have raised with Microsoft / SAP OR if we need to start afresh.

SAP BusinessObjects BI Platform 4.3 Support Pack 3 Patch 1 Version : 14.3.3.4496.1

    • ShankarS's avatar
      ShankarS
      Frequent Visitor
      3 years ago

      Thanks for the quick response, Anonymous -- the SAP KB 2853508 is stating its relevant for BO 4.2 & is not reproducible above BO 4.2 Support Pack 7 Patch 500 and above versions.. But both of us seem to be facing this after updating to BO 4.3 SP1 Patch 1. 

       

      SAP then have to clarify if they are same OR if this is a different issue. I have also raised with SAP, along with here within Microsoft as manual workaround is not practical due to the volume of reports impacted on our end.