Web URL causes error in published report: "The query result is too large".

[BBertels]

Dear,

I have a report where a column is formatted as a hyperlink (Web url). The url is based on a custom column defined in Power Query. (cfr. attached screenshot for config details).

scenario1: web url configured

The published report generates an error "The query result is too large..." when data is not filtered to return a small subset of data. If filters are set to only return few records, no errors. However ...

scenario2: web url not configured (no no web url used for the column)

The published report does not generate an error.

Therefore I think it is a bug, or should I take another approach to get the url implemented without any errors.

PS:

- I already reduced to unused columns, string columns to an absolute minimum. And since it works perfect without the web url config, I really think it is Web url related.

- Power BI Desktop version: June 2022

Thank you for any suggestion.

[v-xiaotang]

Hi @BBertels 

Thanks for reaching out to us.

>> The query result is too large. consider removing unused columns, adding visual filter, or reducing the number of string type columns

Here are some tips about Power BI performance for your reference,

Data reduction techniques for Import modeling - Power BI | Microsoft Docs

2 ways to reduce your Power BI dataset size and speed up refresh - YouTube

Best Regards,

Community Support Team _Tang

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

[BBertels]

Spoiler

Maybe it is related to the same limitation in Excel? 66530 hyperlinks per worksheet