topic Character limit on SSRS report data set in Report Server

Character limit on SSRS report data set

Anonymous — Thu, 09 Jul 2020 15:46:04 GMT

Hi,

I wanted to know if there is a character limit inside the SSRS data set?

We need to decide either to directly write data queries inside the data set or use stored procedures instead.

Also, if theres is any limit to the number of data sets i can create/use in 1 single report.

-Thanks

Yaseen

Re: Character limit on SSRS report data set

saglamtimur — Fri, 10 Jul 2020 07:17:49 GMT

As far as I know Microsoft does not specify a limit for either datasets or character limit inside the dataset fields. But performance may be your biggest concern. In a forum question I read long time ago, a report containing 64 datasets had time out when deploying or HTTP Status 400: Bad Request error. So you need to rethink your design.

If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍

Re: Character limit on SSRS report data set

Anonymous — Wed, 15 Jul 2020 07:37:10 GMT

excellent! thanks saglamtimur

Can we get a final verdict from Microsoft as well for the same (Power BI Report Server septemebr 2019).