Skip to Content
0
Jun 17, 2021 at 07:23 PM

Data preview not working with Excel as datasource BOBJ 4.3

199 Views Last edit Jun 17, 2021 at 07:24 PM 2 rev

Hello,

We are on BOBJ 4.3 SP01 Patch 201, and the data preview option when using Excel as datasource seems to be quirky. When I first add excel as datasource with .xlsx (query1), data preview works fine. But when I add webi query (sap bw query as datasource) also (query2), and go back to query1 (excel datasource) for data preview, I get error that "The resource is not reachable. Please click help for more details". However, when I hit run (combining both queries), and go back to edit mode and hit data preview on query 1, I don't see this error anymore and it refreshes data and data preview works just fine.

Is there any reason for above error in data preview with excel datasource? Is there any special characters or clean-up that is needed before excel file is uploaded to BI launchpad and consumed?