Dataverse Virtual Table Data Retrieving Issue

(0) Share

Report

Posted on by CU04021546-0

Hi All,

I have created Dataverse virtual table with connecting a MS SQL Server table View. The view contains 13 columns & over 80K rows of data. The table is successfully created in Dataverse but data not retrieved. It keeps pops up this error.

Anybody has a clue on this?

P:S -

The data set do have a Primary key in it & I choose it as the Primary field for this virtual table.
I have attached screenshots of how the data looks like in excel. I have used Power Query to retrieve data from SQL Server directly.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

wolenberg_ 1,476 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello there,

Dataverse virtual tables are strict: they need a unique primary key and a straightforward source. If your SQL view meets those conditions, data should load. If not, simplify the view or move to a physical table/Power Automate sync.

Could you share whether your SQL view’s primary key column is truly unique and indexed? That’s usually the first thing to check when data won’t retrieve.

Was this reply helpful? Yes No
Suggested answer

Olufemi 7 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @CU04021546-0,
This is expected behavior with Dataverse virtual tables backed by SQL views.

The table can be created successfully, but data will not load if the SQL view does not meet Dataverse requirements.

Common causes

Primary key not fully supported

Must be a single column

NOT NULL

Unique across all rows

Not calculated or concatenated

Unsupported or large column types

nvarchar(max) / long text

JSON-like data

Computed columns

View complexity or performance

Joins or calculations can cause Dataverse to fail when loading data

SQL permissions

Connection user must have SELECT on the view and underlying tables

Recommended approach

Create a simplified SQL view with:

A clean primary key

Fewer columns

No long text or JSON

Confirm data loads in Dataverse

Add columns back gradually

Cast text columns to nvarchar(4000) or less

Microsoft documentation

Virtual tables limitations and troubleshooting

Create and edit virtual tables

Virtual tables overview

The issue is caused by SQL view structure or data types, not Power Query or Excel.

Was this reply helpful? Yes No