Skip to Content

Importing data from excel in shared path in WEBI

Hi All,

I am trying to import data from a excel file which is placed in a shared folder(eg: \\Computername\ABC.xls ) and not in my local computer using WEBI client.

I do not see any option under Excel as datasource to enter the shared folder location.

I can find only the below options.

Please let me know how i do i enter the shared folder location in WEBI client.

The intention of importing data from shared path is to create the report and save it in repository so that anyone who has access to shared folder can refresh the report.

Regds,

Samson

111.png (44.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 12, 2016 at 06:38 PM

    Hi Samson,

    Did you try entering the filename as \\Servername\ShareFolder\Filename.xlsx? If not, try to Map Network Drive first so that Drive shows up as one of the drives on your machine. But, if you do it that way, you'll have to make sure that the Drive letter used on your machine to map that shared drive should be the same letter with which you'll have to map that network drive on the BO Server.

    Update, even better: Try the below blog, it says exactly what I said about how to enter the filename if its on a Shared drive.

    Creating a Webi doc off of an unmanaged Excel data source on a network share

    Hope that helps.

    Thanks,

    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mahboob,

      Thanks for the reply.

      I followed the steps in the link that you shared ie, entering network share name in the File Name box and it worked perfect.

      Thanks a lot

      Regds,

      Samson

  • Apr 12, 2016 at 07:23 PM

    Hi,

    you can find a simple solution for using excel as datasource for webi here Excel as DataSource for Webintelligence

    Hope that helps

    Andreas

    Add comment
    10|10000 characters needed characters exceeded