how many rows can power bi handle

[MostafaGamal]

Hi All,

I have a question " how many rows can power bi handle ?" 

[Anonymous]

how can we export the data in csv file for more than 150000 rows?

[Anonymous · Accepted solution]

@MostafaGamal 

It depends on the connection mode. For Direct Query, you can returns 1 million rows maximum. If over 1 million rows are returned from DirectQuery, Power BI returns an error (unless in Premium capacity, and the row count is under the admin-set limit).

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs

For Import, there is no limitation on the rows of data you can import into Power BI currently. However, Power BI offers two licenses, Power BI (free) and Power BI Pro, with different data capacity limits:

• Free users have a maximum 1 GB data capacity.
• Pro users of Power BI Pro have 10 GB maximum capacity.
• Pro users can create groups, with a maximum 10 GB data capacity each.

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

For exporting, Currently Power BI has an export limit: 30,000 rows when you export to CSV and 150,000 when you export to Excel.

Detail: Power BI Tips How To Increase the Number of Rows Imported (designmind.com)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[SadieCake]

We are using Direct Query data in PowerBI, per the information you provided in 2020, is there still a limitation on row count in PowerBI (transformation). I am assuming that since this is querying from a SQL DB, there shouldn't be a limitation. However, in one of my reports, I cannot scroll beyond 6419 rows of data, which I find quite peculiar. Please advise.

[MostafaGamal]

I have a pro license, thanks for your reply

[mahoneypat]

It depends on your computer specs, but a typical laptop can handle a model with 10s of millions of rows.  The complexity and correctness of your DAX expressions and the number of visuals/calculations on the report page will dictate responsiveness to slicers, etc.  And the data source and the complexity of the data tranformations you do will govern your refresh time.  

Power BI can handle billions of rows with the right set up.  In demos, they've shown >1 trillion rows.

Regards,

Pat