Skip to Content
avatar image
Former Member

Excel as datasource for WebI report not working

Nov 01, 2016 at 08:11 PM | 44 Views

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
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    AMIT KUMAR
    Nov 01, 2016 at 08:16 PM

    check this.

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Kuldeep Ghosh
    Nov 02, 2016 at 09:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded