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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Nov 01, 2016 at 08:16 PM
0
Share
10 |10000 characters needed characters left characters exceeded
Kuldeep Ghosh 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