Answered

Query data in dataverse from SQL Studio Management - CoE tables

Like (0) Share

Report

Posted on 19 Feb 2021 11:34:14 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?

All responses (3)

Answers (1)

abm abm 32,506 Most Valuable Professional on 22 Feb 2021 at 12:01:10

Like (0)

Report

Re: Query data in dataverse from SQL Studio Management - CoE tables

Hi @sega2

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

Thanks
sega2 87 on 22 Feb 2021 at 07:27:40

Like (0)

Report

Re: Query data in dataverse from SQL Studio Management - CoE tables

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

abm abm 32,506 Most Valuable Professional on 21 Feb 2021 at 22:03:05

Like (0)

Report

Re: Query data in dataverse from SQL Studio Management - CoE tables

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