Data Missing in Table Visual and Filter

Hi, Anonymous 

It may be a known limitation of using directquery .

Limit of 1 million rows returned on any query: There's a fixed limit of 1 million rows placed on the number of rows that can be returned in any single query to the underlying source. This limit generally has no practical implications, and visuals themselves aren't going to display that many points. However, the limit can occur in cases where Power BI isn't fully optimizing the queries sent, and there's some intermediate result being requested that exceeds the limit. It can also occur while building a visual, on the path to a more reasonable final state. For example, including Customer and TotalSalesQuantity would hit this limit if there were more than 1 million customers, until some filter were applied.

The error that would be returned would be: "The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows."

---

Users of this table can only see 1,000,000 rows at any time. This causes them need to filter down to a fine-grained level in order to find exactly what they want.

It is suggested  that you create an additional granularity slicer applied on the table.

For example, you can extract the first character of the email address  to create a new calculated column as a new slicer.

First character = LEFT(Table[EMAIL],1)

In this way,  you need to filter out all email addresses starting with "j"  through this  new slicer first, and then you can filter out the specific "[email protected]"  through your original slicer.

Best Regards,
Community Support Team _ Eason