Pulling SQL virtual table into Dataverse showing incorrect row counts

(1) Share

Report

Posted on by msm85042

Hello,

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 that 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 confusing to end users. I'm not seeing any settings or blogs on if this can be changed. The screenshot shows my issue:

All responses (1)

Answers (0)

simondisk 14 on at

Like (0)

Report

Pulling SQL virtual table into Dataverse showing incorrect row counts

Side info: the same happens when using Virtual Table on Oracle Database.

Showing 5000+ results although there are only 2 rows