Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

Hi,

 

I have built a calculated table using the following expression:

Missing From CMDB =
SELECTCOLUMNS (
    CALCULATETABLE (
        IT_Current,
        EXCEPT ( VALUES ( it_current[ip_address_rapid7] ), VALUES ( CMDB_Active[IP_Address] ) )
    ),
    "IP_Address_Rapid7", IT_Current[IP_ADDRESS_RAPID7],
    "Host_Name", it_current[host_name_rapid7],
     "operating_system", it_current[os_description]
)

Unfortunately when I run this I receive the following error:
<ccon>The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows.</ccon>
2 REPLIES 2
TomMartens
Super User
Super User

Hey @Anonymous ,

 

there is a limit of 1M rows for directQuery, you can expand this limit if you are using Premium Capacity (Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn)

Nevertheless, you might use SUMMARIZE (SUMMARIZE – DAX Guide) to "group" the columns you want, before you use SELECTCOLUMNS to rename the columns.

Hopefully, this provides some ideas on how to tackle your challenge.

Regards,
Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

What would the query look like if I wanted to just show distinct values of "it_current[ip_address_rapid7]" within my calculated table function?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.