the result set of a query to external data source has exceeded the maximum allowed size

[pallavisave7]

the result set of a query to external data source has exceeded the maximum allowed size in power bi. The data has exceeded maximum allowed size of 1000000 rows.

I'm using directquery for data and can not switch to import switch to import mode.

[v-yangliu-msft]

Hi  @pallavisave7 ,

You can work to get the repeated lower-cardinality attributes set up as a separate table that only returns the distinct combinations - this is commonly referred to as a dimension table and it might be worth reading up further on the concept of star schemas.

• Power BI documentation
• SQLBI - The importance of star schemas
• RADACAD - Power BI Basics of Modeling: Star Schema and How to Build it

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/The-resultset-of-a-query-to-external-data-source-has-exceed...

https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/

https://forum.enterprisedna.co/t/to-use-direct-query-in-importing-dataset-which-size-is-great-than-1...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. Have you considered applying aggregations?