Forum Discussion

ShankarS's avatar
ShankarS
Frequent Visitor
3 years ago

Excel Connector fail to load last column from excel file created by Business Objects Platform 4.3

Creating this as a new post to get inputs from community experts, although this is highlighted as part of below thread and I have just submitted an Issue thread.

 

It is noticed that Excel Connector in Power Query is starting to fail loading the last column of excel file created by Business Objects platform 4.3. This is primarily happening when we update the Business Objects platform to 4.3 Support Pack 3 Patch 1 Version : 14.3.3.4496.1

 

Note that the excel file created by the Business Object platform (both prior to above patch update and after the patch update) continue to have the column that fails to load thru the Power Query Excel connector. The trouble shooting is pointing to the Excel Connector not detecting the End of Line in the excel files created after the patch update and if any dummy column is added manually to these files, the required column also gets loaded properly in Power Query.

 

  • Who own the Excel connector for Power Query and how best to reach out to them?
  • Will they look for resolution / reach out to SAP Business Objects team for resolving this?
  • OR is this not owned / expected of them and it only need to be taken up with SAP Business Objects?

 

Reference:

PBI Excel connector missed loading last column fro... - Microsoft Fabric Community

https://community.fabric.microsoft.com/t5/Power-Query/Columns-missing-from-imported-Excel-data/m-p/3280087#M105807

 

Thanks in Advance !

 

 

 

 

2 Replies