Skip to main content

Troubleshoot `TOO_MANY_ROWS` in Power BI

Resolve the Power BI row limit error when a Data Share contains too much data for one month.

Problem summary

Power BI cannot load a Data Share when one month contains more data than the connector can return.

Error message or symptoms

Power BI returns the error TOO_MANY_ROWS.

When does this occur

  • The Data Share contains too much data for one month.

  • The Rolling months range includes the affected month.

Root cause

The Power BI connector limits how much data it can return for one month. The error does not mean that an incoming data source has stopped downloading.

Solution

  1. Check the Rolling months value in Power BI.

  2. Reduce the value if this change excludes the month that contains too much data.

  3. If the error continues, contact Funnel support. Include:

    • The Power BI export link.

    • The complete error message.

    • The first date when the export failed.

Microsoft also documents this limitation in the Funnel connector for Power Query.

Did this answer your question?