Data not refresh after increase in MaxFileSizeMb

[Anonymous]

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

[mwegener]

Hi @Anonymous ,

are there any clues in the logs?

[Anonymous]

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

[Anonymous]

@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. 

[Anonymous]

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

[Anonymous]

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 

[Anonymous]

@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

[mwegener]

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/