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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
teaguejs
Helper II
Helper II

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 @teaguejs ,

 

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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