Paginated report: Limitations and performance

[vilenm]

Hi

We currently using premium workspace with paginated option. What are the limits of exporting data ? And is there a performance conern when using tabular dataset as source for pagination? Would SQL be better as the source?

Thanks

[amitchandak · Accepted solution]

@vilenm , Power bi Premium has 400GB data size per dataset.

https://powerbi.microsoft.com/en-au/pricing/

For the hardware capacity you have to choose a Premium capacity, there are a few.

Power bi works best with Import mode, The dataset can be used later as a power bi source (Power bi dataset) live connection. You can use power bi dataset for paginated report