How to bypass the hard limit of a 30K row data view for visuals

[DavidSweden]

Hello,

I have a custom visual connected to an Excel file that is 44 MB in size and contains approximately 900,000 rows. When I add this datasheet to the custom visual, I encounter an issue where not all data is displayed, as shown in the picture below.

I understand that Power BI imposes a hard limit of 30,000 rows for visuals, which is significantly below my 900,000 rows.

I later discovered that you can fetch more data via an API. I have attempted to implement this method into my visual.ts file but have not been successful.

For reference, here is the documentation I followed: Fetch More Data.

My question is: Will this approach work, or am I spending time on something that is impossible to resolve?

Thanks in advance! 

[Anonymous · Accepted solution]

Hi  @DavidSweden ,

You can check aggreagates data in Power BI, if only two fields are used in the visual object but the table contains more fields, the data will be grouped by these two fields and only the unique fields of the data rows for these fields will be displayed.

You can also check the official limitations related to fetchMoreData API:

Fetch more data from Power BI - Power BI | Microsoft Learn

This is the related document, you can view this content:

Solved: How to Make a Table Visual Exceed 500 Rows / Looki... - Microsoft Fabric Community

this.host.fetchMoreData() not working on initial l... - Microsoft Fabric Community

Solved: Custom Visual fetchMoreData function not respondin... - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DavidSweden]

The visual work with the Excelsheet like the picture below.