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?