topic Re: Report server on premise - how to change size of max dataset in SSMS in Report Server

Report server on premise - how to change size of max dataset in SSMS

Anonymous — Mon, 29 Jun 2020 08:32:35 GMT

Hi everybody,

I have a problem with some datasets that need to be available in reporting server. Unfortunately we passed the limit of 1GB.
From the change logs i can see that there is an option to change the dataset size from default 1GB to 2 GB but i cannot find in the config.

Have someone did it and can pass me a screen where the option is ?

Thanks in advance!

Re: Report server on premise - how to change size of max dataset in SSMS

saglamtimur — Tue, 30 Jun 2020 07:00:11 GMT

Do you mean max file size? If so from Server Properties -> Advanced

Re: Report server on premise - how to change size of max dataset in SSMS

Anonymous — Tue, 14 Jul 2020 12:26:13 GMT

saglamtimur Thanks for help, i chacked on 2 instances but i have completely different GUI and no field like that.

The Tree is the same but has a lot more options in my case. 😞

We have raw PowerBI RS not SSMS . i looked in config.web aswell but there are no options like that.

So i'm stuck with 1 gb max filesize.

Re: Report server on premise - how to change size of max dataset in SSMS

saglamtimur — Tue, 14 Jul 2020 14:06:10 GMT

Power BI Report Server creates a database and "Server Type" which you can connect with SSMS. Where are you looking for this configuration? You must connect to "Reporting Services" "Server Type" with SSMS even it's Power BI Report Server. It's 99.99% percent same. Here is a short video, I have recored for you to show how to do this. Hope it helps.

Video Link

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 👍