Answered

Query data in dataverse from SQL Studio Management - CoE tables

(0) Share

Report

Posted on by sega2

I have installed the CoE package and want to query some tables. I tried following queryes and I kan see there should be results:

SELECT admin_displayname FROM [dbo].[admin_app] where admin_displayname='Compass Wind Backend'
SELECT admin_displayname FROM [dbo].[admin_app] where admin_appid='81139F17-C767-EB11-xx-000D3AB40D42'

However it returns 0 results. I can see there is data with admin_displayname='Compass Wind Backend' if I do a select * from ...

Is it not possible to do normal SQL queries towards dataverse?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

abm abm 32,928 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @sega2

Yes can do normal SQL queries to execute under Dataverse.

Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Docs

Try removing the conditional part and see what records are retrieved. It must be something wrong in your filter condition value.

Thanks

Was this reply helpful? Yes No
sega2 87 on at

Like (0)

Report
Copy link

Link copied!

With no filter I can fine thr record fine. I copied the filter condition value that way.

Was this reply helpful? Yes No
abm abm 32,928 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @sega2

Could you please post a screenshot of your query and results? Also the data in SQL.

Thanks

Was this reply helpful? Yes No