Skip to Content
0

Excel as datasource for WebI report not working

Nov 01, 2016 at 08:11 PM

29

avatar image
Former Member

Hi Experts!
I have Version 4.1, sp7, so the feature is installed and I am able to choose Excel as a Source when I create a New report. But as I browse the folder structure in BI Launch Pad, I can't find my Excel sheet anymore, and hence I can't choose it.
I have a hunch of what the problem is, because even though the Excel file has Type Excel from the Launch Panel view, it has th postfix .csv if I choose Organize > View..

So probably the reason the file is not visible when I choose Excel as a datasource, it is in fact a CSV file, even though it has the icon and the type of an Excel file.
Why is this happening and how can I fix this?

SAP Knowledge Acceleration, version for SAP BusinessObjects Web Intelligence
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sort by:
avatar image
AMIT KUMAR Answered
Nov 01, 2016 at 08:16 PM
0

check this.

https://blogs.sap.com/2013/11/25/new-in-sap-bi-41-sp02-microsoft-excel-as-data-source-for-web-intelligence/

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
avatar image
Kuldeep Ghosh Answered Nov 02, 2016 at 09:17 AM
0

Convert the .csv file to .xls/.xlsx excel format. Use Webi Rich client if you need to report on .csv file. I dont think .csv would work via BI Launchpad

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users