Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Character limit on SSRS report data set

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.   Als...
Data set
dataset
SSRS
saglamtimur's avatar
saglamtimur
Icon for Resolver II rankResolver II
6 years ago

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 👍

Anonymous's avatar
Anonymous
Not applicable
6 years ago

excellent! thanks saglamtimur 

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