topic Re: Could PowerBI Report Server increase limitations? in Report Server

Could PowerBI Report Server increase limitations?

Anonymous — Tue, 12 Dec 2023 11:06:22 GMT

Hi everyone,

I've a questions about PowerBI Report Server limitations.

In my company we are using PowerBI Desktop and then publish our reports on PowerBI Service.

The fact is that we've challenges with the volume of our data to fit with the default PowerBI visuals.

Regarding the documentation and the experimentations I made I found those limiatations for my usages (PBI Service):

PowerBI Default visuals: up to 30k data points (rows), depends on the visual
R/Python Scripting: up to 150k rows (TOP reduction strategy applied)
Custom Visuals (SDK): up to 30k rows (table DataViewMappings) (Top, Bottom and Sample strategies applicable)
Custom R Visuals (HTML payload): up to 150k rows, payload < 2Mb (table DataViewMappings) (Top, Bottom and Sample strategies applicable)

My question now is whether it would be possible to switch to Report Server to manage and overcome these limitations? Is it possible to set these limitations in PowerBI Report Server?

Thanks in advance guys 👍

Re: Could PowerBI Report Server increase limitations?

d_gosbell — Tue, 12 Dec 2023 20:45:09 GMT

Anonymous wrote:
My question now is whether it would be possible to switch to Report Server to manage and overcome these limitations? Is it possible to set these limitations in PowerBI Report Server?

No, Report Server has these same limitations in terms of visuals and in general Report Server has more restrictions than the service. Have you looked at possible strategies for aggregating / summarizing your data to work within these limitations? This would have the extra benefit of potentially making your reports faster to load.

Re: Could PowerBI Report Server increase limitations?

Anonymous — Wed, 13 Dec 2023 08:30:19 GMT

Hi and thanks your your answer.

Yep I looked for those possible strategies and I think this is the only way I can handle my problem.

As we can't manage the settings of reductation strategies (high density sampling for scatters and lines and other reductions strategies in other charts), I will be necessary to find some methods that perfectly fit the PowerBI charts limitations.

Thank you and have a good day