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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
MeenaSankar
Frequent Visitor

Power BI to funnel.io connector

Hello champions,

 

I am hoping you can help me with a question I have on the funnel.io connector from PBI.

 

In the documentation, its mentioned that "If a Data Share contains too much data for one month, the connector will get a TOO_MANY_ROWS error."

 

Can someone advise how many rows are considered too many rows. Also, just wondering why the statement reads too much data for one month . Does that mean that there is a data limit on the maximum number of rows for a given month or does that say there is a data limit on the maximum number of rows for the whole extract (which could be more than one month)

 

Thanks in advance.

1 REPLY 1
foodd
Super User
Super User

This message is usually displayed when there's lots of data in your account, and you are trying to view too much at the same time. Remember, Funnel is a monthly Subscription, especially when viewed from a Consumption standpoint.

 

Funnel can process up to 100,000 rows per query in the Data Explorer; if the number of rows exceeds this threshold, the "Too many rows, try using a shorter date range or fewer dimensions." This is an error message returned by Funnel, which indicates that the query would result in too many rows and was therefore aborted.  Funnel does this for performance reasons and to avoid sending huge or incomplete responses.


There are a few different things you can do to handle this situation, but more or less, it all boils down to reducing the cardinality of the data returned.

The simplest way to do this is to reduce the segmentation in your query, i.e., by removing a dimension or a filter. Time series widgets will always include the Date dimension, which means that if a time series widget fails to load, you can either reduce the time span or use another type of widget that displays the totals for the request period.

 

From a practical standpoint, these issues are a dependency on Funnel's offerings and are in no way tied back to Power BI or a related service.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.