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.
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:
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.
how can we export the data in csv file for more than 150000 rows?
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:
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.
I have a pro license, thanks for your reply
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |