I'm getting these nice looking tables/error messages and was wondering whether there's a way to either not show anything until a filter/slicer is selected or limit the results to less than 1 million/thousand/100 results or something to avoid the error? Thanks!
So no dice if using tables instead of slicers? (say 2-3 tables where some have high level information and others more detailed , and you just select a row and then get the detailed view in the other table (say 5-10 detailed rows per 1 high level row). obviously the detailed table has more rows than others, more than 1 million if no rows is selected )
It is not supported to hide/show a visual based on slicer selection. Such an error prompted because the Maximum number of rows returned in a DAX query is limited to 1 million rows by default. To increase the upper limit, you could specify the MaxIntermediateRowSize configuration setting in the msmdsrv.ini configuration file. Reference: DAX Properties
Community Support Team _ Yuliana Gu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I just want to show an empty table if no slicers/filters are selected.
Partially to avoid getting the error, but also because it's only going to show a lot of information which is irellevant until filters are selected, so would be nice to be able to say "here's an empty table, but if you select a filter/slicer, or you click on anything in this other table which will also work as a filter, then I'll show you some data"!