Couple of questions that I am hoping to clear..
1. What is the max number of connections (web services queries via BIWS) allowed in dashboards?
2. I have around 8 blocks of data (1 web service, 8 methods) that I need to import into a dashboard for desktop use only. Is this the recommended option or should I create 8 different web services for performance reasons?
3.Among 8 blocks of data, I realized that 2 of them have approx 2000 rows. I increased the excel preference to 2000 rows and then imported the methods/web service in dashboard and realized that the size of the dashboard grew to sightly more than 1MB. As I was finalizing the dashboard, it froze and excel got corrupted, hence cannot open the xlf file any more 😔. I am using only concatenate function (&) in excel.
I tried to retrieve xldoc.xls, but no luck 😔
Any help will be great.