Data limit suddenly causes error in table visual. Bug in Power BI Desktop June 2025 update?

Hello Eric,

Summary of issue: After the June 2025 release of PowerBi I found that my "Data Limit" applied to a Table visual suddenly caused the error:

"Error fetching data for this visual": see details: "When a filter condition uses the In operator with a Table argument, all of the Expressions and all of the projections in the Table must be column references." This error occurred with (I believe) no change to underlying data.

My table had a mix of text, date, and summarized numeric columns.

Mitigation: I was able to find 2 workarounds that worked for my scenario. Each has drawbacks.

• Workaround 1: the most tedious and annoying: I build the report in Desktop with NO data limit and then publish to web. Once published to web, I apply the data limit in the web editor and it worked fine (even with summarized numeric columns). This was a less than ideal resolution because of the manual work required each time I wanted to update my report.
• Workaround 2: very easy and workable for me, but will not work for those who want summarized numeric columns in a table. I re-built my table from scratch with the data limit applied, and noted which columns "broke" the visual (meaning- gave the error mentioned above). Numeric columns were the ones with an issue, and text and date columns had no issue. Furthermore, I tried toggling my summarized numeric columns (i.e. Sum, Average, Count, Median) and found that "Don't summarize" removed the Data Limit error. This workaround will not work if you actually do need summarized columns.