Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I didn't find the real limit size of my .pbix in when I upload it on my Power BI Report server (not using the Power BI Services scenario).
1. What is the limit using import mode ?
2. What is the limit, (maybe in rows) for direct querry ?
My users need an answer to these limits and also the maximum rows displayed in a visual ?
Thanks !
Solved! Go to Solution.
@michaeldurieux2 wrote:
1. What is the limit using import mode ?
The max filesize in Power BI Report Server is 2Gb
2. What is the limit, (maybe in rows) for direct querry ?
I don't believe there are any limits like this for direct query. In this mode the report sends SQL queries to another database, so the amount of data that can be held and the performance of the queries is largely governed by the source database system. The only limit you may hit is that the server cannot send a resultset of more than 1 million records back to the client. This is not usually a problem as Power BI typically generates aggregate queries that do GROUP BY operations.
@michaeldurieux2 wrote:
1. What is the limit using import mode ?
The max filesize in Power BI Report Server is 2Gb
2. What is the limit, (maybe in rows) for direct querry ?
I don't believe there are any limits like this for direct query. In this mode the report sends SQL queries to another database, so the amount of data that can be held and the performance of the queries is largely governed by the source database system. The only limit you may hit is that the server cannot send a resultset of more than 1 million records back to the client. This is not usually a problem as Power BI typically generates aggregate queries that do GROUP BY operations.
I've a fact table with 26697328 rows and I do not see any issues/slowness.
Pbix file size is 200MB. this is the max i worked with so far.
PBI is very good at reducing size/caching.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
7 | |
3 | |
3 |