Skip to Content
Former Member
Sep 04, 2013 at 09:41 PM

BIWS limitations (performance issues)


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.

Thank you



error.png (16.5 kB)