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?