Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Community,
Why does Power BI have a limitation of 1,000,000 rows, and are there any workarounds to overcome it?
Can I get some help with this please
Thanks,
Solved! Go to Solution.
Hello @GopinathSunduru ,
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
Proud to be a Super User! | |
Hello @GopinathSunduru ,
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
Proud to be a Super User! | |
@GopinathSunduru
Are you referring to per Max intermediate row count limit with direct data models? https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-premium-workloads#max-intermedia...
If your data model hosted in a workspace which is premium capacity then you can change the limit, but this can impact the database if the reports are not optimized.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun