Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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://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 , 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://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
@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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |