Pulling SQL virtual table into Dataverse showing incorrect row counts

(0) 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:

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

rulesrchanged1 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This seems to be related to model driven app, so i will suggest posting this in Power Apps forum and someone shoudl be able to help

Was this reply helpful? Yes No
msm85042 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I moved this question to the Power Apps forum. I didn't realize I had created it in the Power Pages forum initially

Was this reply helpful? Yes No