Forum Discussion

arnomics's avatar
arnomics
Helper I
3 years ago

Query to external data source has exceeded the maximum allowed size of '1000000' error - Directquery

Hey all,   I have an issue which I've been unable to get my head around for quite some time & I was hoping someone out here could help me troubleshoot.   I have a Composite Model where I've got a...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

arnomics , Try a measure like

 

calculate(DistinctCount('Mobile'[ID]), filter('Service','Service'[Type] = "Prepaid"))

  • arnomics's avatar
    arnomics
    Helper I
    3 years ago

    Thanks amitchandak . I tried this Measure and yes, it gives a perfect/correct count for 'Prepaid' Services. However, when I try to use this as a Filter on a Table Visual where I'm trying to show Mobile IDs that are part of the Measure, I get the same error ""The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows." 

     

    I'm not sure exactly what the problem is but I think it is still querying the whole Mobile table. Would a Measure that returns Y or N where we have a 1 help?