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

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

Anonymous 

I haven't experienced this myslef, but it seems you are not alone (there was a thread recently about a similar issue).

As for solutions... is the data within the page formatted as a table? (select all cells and ctrl +t).

If the data is in a table within Excel, Power Bi will recognise the table (as an entity) and you can select it in the import process. 

Does that help?

 

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