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.

 

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

 

-Thanks

Yaseen

 

Data set
dataset
SSRS

2 Replies

  • saglamtimur's avatar
    saglamtimur
    Resolver 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).