This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Hi All,
I am facing an issue with filter in one of my reports.
If I exclude a particular value from the filter - my report gets broken. If I don't use the filter and keep all as a selection, then it works fine. This is the error message I am getting -
'Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed.'
Can anyone help me on this, how to resolve this issue?
Thanks!
Hi @Anonymous ,
Check if increasing size as shown below helps in your case.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is this a composite model? Is your key column which is connecting the models marked as a text field? Does that field have high cardinality?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 23 | |
| 20 | |
| 20 | |
| 20 | |
| 20 |