Answered

TDS Endpoint, SELECT query doesn't return correct results

(1) Share

Report

Posted on by SantoVG

Hi all,

since yesterday I'm having a problem with TDS "connection" to Dataverse. I know this functionality is still in a preview and shouldn't be used in production but I'm just wondering if someone else has the same issue.

So, the problem occurs when I run simple SELECT query with one WHERE condition. First time I run query I get 0 records and second time I run the same query I get 1 record as it should be.

Query is very simple:

SELECT *
FROM entity
WHERE entityid = 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxxxx'

any ideas?

Thanks!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Santo992 :

I've made a test and encountered the same problem you mentioned.

This problem will only occur during the first Execute.

Because this is a preview function, there may not be a good solution at present.The only solution I can think of at the moment is to create a support ticket.

Hope this helps.

Best Regards,

Bof

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Santo992 ,

This is a shot in the dark, but can you try selecting specific columns vs. * to see if it works successfully when targeted at specific columns on the query?

Thanks much,
Drew

Was this reply helpful? Yes No
SantoVG 23 on at

Like (0)

Report
Copy link

Link copied!

Hi @dpoggemann ,

the original query is written without * and the problem still occurs. Just in case I've just executed query with only one column in select and the problem is still here.

Every time I execute query for the first time I'll get 0 records, but second time I'll get correct results. If I have 2 queries with different WHERE condition and I execute them in turns I'll always get 0 records.
For example:
Query 1: 0
Query 2: 0
Query 1: 0
Query 2: 0
Query 2: 1
Query 1: 0
Query 1: 1
Query 2: 0

Josip

Was this reply helpful? Yes No
Mark Carrington 36 on at

Like (1)

Report
Copy link

Link copied!

I also observed this behaviour starting from yesterday. Sometimes my query would return as expected, other times it would return 0 records (but with the expected columns)

Was this reply helpful? Yes No
EnterTheDragon 3 on at

Like (0)

Report
Copy link

Link copied!

We too are having the same issue with TDS endpoint. Some times it returns records and sometimes 0.
Looking for some solution to it else would need to use DataExportService or Web Api

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Santo992, @EnterTheDragon, as @v-bofeng-msft mentioned I would create a Microsoft support ticket at: https://admin.powerplatform.microsoft.com/support. Keep us posted of the resolution! Cheers

Was this reply helpful? Yes No
SantoVG 23 on at

Like (0)

Report
Copy link

Link copied!

My quick fix is to run query one more time if the first result count is 0. This way I can still use TDS in my application but the downside is that everything is called twice.

Was this reply helpful? Yes No
Verified answer

vikasp Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi, Sorry for the delayed response on this issue.
We've fixed this issue and is now rolling it out to all the Geo's. The fix is currently available across most of the Geo's and will be deployed to EMEA during the weekend of 3/19 and NAM during the weekend of 3/26.

Was this reply helpful? Yes No