I've currently configured a Virtual Table within our Dataverse environment using the SQL Server connector. Everything is setup correctly and no issues getting data pulled in. However, I do notice the record count for my virtual table is showing 5000+ threshold even though there are only 122 records in the related SQL table. Is there any way to configure the virtual table to show the correct number of records within Dataverse? I'd like it to say 1-122 of 122 to reflect the correct record count as the 5000+ record count is misleading to end users. I'm not seeing any settings or blogs on if this can be changed. The screenshot shows my issue:
I had the same problems. Also I also received "Paging cookie is not valid" error when calling the data access API. The OData returning the record count -1. I deleted and recreated the virtual table, same problems.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.