Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Query data in dataverse from SQL Studio Management - CoE tables

Posted on by 87

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?

  • abm abm Profile Picture
    abm abm 32,222 on at
    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 Profile Picture
    sega2 87 on at
    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 Profile Picture
    abm abm 32,222 on at
    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,685

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard

Featured topics