Hi all. I have a dashboard that is fed via BIWS generated from scheduled WebI reports. The dashboard was developed in 4.1. There are 15 data services picking data up from 15 BIWS. I had to change the host server on the BIWS and go through changing the data services on the dashboard. Now only 3 of the 15 are pulling the data through to the dashboard. I cannot see that I have set up the data services any differently and when I test the BIWS in Web Service Publisher they are showing as returning data. Can anyone advise what might be happening or how to debug it please? Thanks.
Thanks for the response. I’ve done some more investigation setting up a spreadsheet table and it seems that the data is coming through but for some reason just the first column. Can’t work out why. It wasn’t doing this before. The BIWS are the same ones, I’ve just changed them to publish to a different host server. Any ideas?
Ok…sussed it out in the end. It was because when mapping the data services to the xls sheets I had entered the parameters in Cells and Rows. When I did it just in Cells it worked ok and then populate Rows without me needing to add it in. Thanks for your help.