Limitation of 1,000,000 Rows in Power BI and Workarounds

[GopinathSunduru]

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,

[Idrissshatila · Accepted 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:

• 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

[tharunkumarRTK]

@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