Thanks Will, I modified the properties and found the following:
1. Continues to display the error message when the SQL Server table is used. "The dataset contains too many records: Try reducing the size of your dataset by filtering it or adding less than 100,000 entities"
2. Now, when using the hosted entity layer service, the message changes to a warning "Can not show all entities, click to get more information", which allows working with Insights cards and interacting with the Map.
In other words, to be able to work directly with more than 100,000 records of an alphanumeric SQL server table, you would need to previously spatialize the data (provide a point service) and modify the properties in the ArcGIS server.
Thanks for the help.