topic Re: Data not refresh after increase in MaxFileSizeMb in Report Server

Data not refresh after increase in MaxFileSizeMb

Anonymous — Fri, 14 Feb 2020 12:30:33 GMT

Hi,

I have On-Premises Power BI solution, my dashboard size get increase from 1 GB so that i increase MaxFileSizeMb to 2 GB in report server. the change effect is that now for old publish dashboard and report data can not get refresh automatically, secondly in old dashboard data not increase from 1 GB.

pls guide what could be issue and how to set data upload / refresh automatically.

Thx

Re: Data not refresh after increase in MaxFileSizeMb

mwegener — Mon, 17 Feb 2020 07:16:52 GMT

Hi Anonymous,

check the logs relevant for scheduled refresh of Power BI reports

https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot#tools-for-troubleshooting

https://www.linkedin.com/pulse/size-models-power-bi-report-server-romain-casteres/

Re: Data not refresh after increase in MaxFileSizeMb

Anonymous — Mon, 17 Feb 2020 07:41:17 GMT

Anonymous

The only way to increase the capacity is purchasing premium capacity. Without premium capacity, the max model size is limited to1GB. Change the MaxFileSizeMb in report server will not effect the capacity limitation in power bi service.

PaulZheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Data not refresh after increase in MaxFileSizeMb

Anonymous — Mon, 17 Feb 2020 09:52:30 GMT

thx. can u please share Microsoft documents.

not able to publish dasboard with more than 1 GB data.

as far as i know MS Power BI On-Premises solution license in two ways, premium and go for SQL Server Enterprise Edition with SA.

We have license with SQL Server Enterprise Edition with SA.

i don't think so its depended on license.

pls guide.

thx

Re: Data not refresh after increase in MaxFileSizeMb

Anonymous — Tue, 18 Feb 2020 01:42:35 GMT

Anonymous

What you mentioned are the two ways you can get the product key for Power BI Report Server: Power BI Premium and SQL Server Enterprise Software Assurance (SA).

For report server see this:

https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server#before-you-begin

However, you cannot take advantage of SA when you comes into Power BI service. They are two different products.

For Power bi service, the capacity section mentioned the max model size:

https://docs.microsoft.com/en-us/power-bi/service-basic-concepts

Check difference between Power BI service and Report Server:

https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service

Paul Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quicly

Re: Data not refresh after increase in MaxFileSizeMb

mwegener — Fri, 21 Feb 2020 22:13:29 GMT

Hi Anonymous ,

are there any clues in the logs?

Re: Data not refresh after increase in MaxFileSizeMb

Anonymous — Mon, 24 Feb 2020 06:40:24 GMT

Hi,

i didn't get chance to see log, i tried to directly upload file from report server portal than able to upload file.

but desktop version not allowed.

thx