Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Excel File source skipping 1 column

Hi Gurus!!!   I am facing a weird situation.  I am creating a xlsx file from SAP BOBJ platform (Webi scheduling or Publication for people knowing this kind of environment).  When I open the file ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Paul

     

    Thanks for the feedback! As I thought this was coming from the way PBI was reading the file, I searched if someone had the same issue but did not find any solution.

    So got back to my SAP background and check OSS notes...I was lucky with excalty that problem description.

    So, people should upgrade the BI platform to BI 4.2 SP7 Patch 500 as per OSS note 2853508

     

    But, as applying a patch is not necessary easy, the work around is to add a "dummy"column at the end of the table and then, PBI will take all the columns excep the last one...

     

    PY

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Paul

 

Thanks for the feedback! As I thought this was coming from the way PBI was reading the file, I searched if someone had the same issue but did not find any solution.

So got back to my SAP background and check OSS notes...I was lucky with excalty that problem description.

So, people should upgrade the BI platform to BI 4.2 SP7 Patch 500 as per OSS note 2853508

 

But, as applying a patch is not necessary easy, the work around is to add a "dummy"column at the end of the table and then, PBI will take all the columns excep the last one...

 

PY

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

Anonymous 

 

Thanks for the update and the pointer towards the SAP notes. Can we take this as a solution? if so, can you mark your last post as a solution since it will help others find the solution when searching...

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Paul!

     

    Just did the update with also a workaround in it...

     

    PY