SSMS - can't see all custom entities as a system administrator

(0) Share

Report

Posted on by jonheb

164

Hey all,

I'm trying to see dataverse tables in SQL Server Management Studio. Unfortunately I can only see 4 out of 7 custom entities there, even though I'm using a system administrator account.

When logging in in normal PowerApps I can see all tables just fine, only in SSMS they aren't there. The 4 tables I can see exist a few month longer, the 3 other tables I can't see are around 1-2 weeks old. All are configured the same.

Does anyone have an idea how I can be able to see them or what could be a reason for this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @vobius ,

I have had this issue as well. I am able to query the table but it does not show in the Object Explorer. IS this the situation you have as well? Are you able to query the table successfully? Have you tried refreshing the intellisense cache? Edit -> IntelliSense -> Refresh Local Cache or CTRL + SHIFT + R?

Was this reply helpful? Yes No
jonheb 164 on at

Like (0)

Report

Yes, thats the exact same problem I'm facing. Unfortunately the refresh of cache didn't work, but I'm able to run queries against the tables.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

Hello, @vobius and @dpoggemann, can this compatibility issue be the reason?

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query#sql-server-management-studio-preview

I have just connected to my Dataverse last weeks and I can see all custom tables but my SSMS version build is 18.12.1

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

Like (0)

Report

Mine is the same version 😥

Was this reply helpful? Yes No
jonheb 164 on at

Like (0)

Report

I also have the same version, so apparently no version or compatibility issue..

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@vobius, just following up, did you figure out the issue?

Was this reply helpful? Yes No
jonheb 164 on at

Like (0)

Report

Nope, no chance to figure it out. Seems like a strange bug.

Was this reply helpful? Yes No
Ben Thompson 1,400 on at

Like (0)

Report

Based on previous similar issues I wonder if the only fix is to update your security roles (add a random one), disconnect and recreate the connection to the database and see what happens. That should refresh any caches and hopefully fix things...

I had a similar issue where I could see 2 out of 3 tables (but not a recently created one). Adding a security role fixed things for reasons unknown...

Was this reply helpful? Yes No