Forum Discussion
directquery query to external datasource has exceeded
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,
KellyDid I answer your question? Mark my post as a solution!
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
Community SupportHi 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
Kelly