Ideal Pages and Size of Report

[Anonymous]

Dear team, 

I need a small suggestion from you all. 

I am currently working on a project which will monitor live daily data. An excel sheet for each data will be added in folder path.

Properties of one excel file:

Size: 530kb

Sheets used: 4

Columns: 13

Rows:206

As of now, I have 15pages in my report. What can be the maximum page limit so that report does not take too long to load and display data?

Questions:

1. Can I have a report of 25-30pages? Will the loading time be affected?

2. What is the maximum folder size as daily if I am adding a file of 500Kb, then in a month only it will be close to 16mb. Is there a source folder size limit?

3. What can be the maximum number of rows Power Bi supports as my daily file adds 206-210 rows?

Thanks in advance!

[amitchandak · Accepted solution]

@Anonymous , there no such limit may be 250 pages.

The limit in terms of size is user workspace 1 GB for free, 10 GB for Pro. I think 100 TB for premium

Max row in term of the direct query is limited 1M per query

References:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-manage-your-data-storage-in-power-bi...

https://community.powerbi.com/t5/Desktop/Number-of-records-limitation/td-p/9552

https://community.powerbi.com/t5/Desktop/Power-BI-10-000-rows-limit-Question/td-p/17715

[Anonymous]

@amitchandak @parry2k 
At present I have 25 pages in my report which may go as high as 35-40.

size of report as of now is 1286kb which may go as high as 2MB.

Will that size be normal and ideal or it can create increased loading time or other issues?

Please suggest.

Thanks in advance

[Anonymous]

Thankyou @amitchandak for the quick response.