Excel File source skipping 1 column

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