directquery query to external datasource has exceeded

[Anonymous]

Hi,

i m using On-Premises Power BI Solution and its license. when using direct query getting following error, 

when search find Power BI cloud has option to increate capacity, pls guide how can i increasae capacity On-premises implementation.

pls advise.

thx

[amitchandak]

@Anonymous 

Direct query limit rows not more than 1 Million on a visual

Refer : https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

"This situation can occur with a simple chart that includes a very high cardinality column, with the aggregation option set to Don’t Summarize. The visual needs to only have columns with a cardinality below 1 million, or it must apply the appropriate filters."

Try to reduce query

https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages

https://guyinacube.com/2019/01/30/power-bi-query-reduction-when-using-directquery/

[Anonymous]

Hi,

how about following link which say increase capacity limit on Power BI cloud. Is this option available for On-Premises BI solution.

pls guide.

thx

https://powerbi.microsoft.com/en-us/blog/five-new-power-bi-premium-capacity-settings-is-available-on...

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

A premium capacity can only affect the supported storage size of capacity ,but as for 100m rows,it is a limitation for direct query,there's no way to enlarge the limitation of direct query.But you can use aggregation or other queries to reduce the lines you need to load to your model.

Here is the reference.

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!