Forum Discussion
Could PowerBI Report Server increase limitations?
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 👍
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.
2 Replies
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.
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