Power Apps Dataverse tables (Views) are not visible in SSMS or Azure Data Studio.

(1) Share

Report

Posted on by Sai97

Hi Everyone,

I have been seraching this everywhere and was not able to find a solution anywhere and was wonddering if is it even possible?
The sitaution is that i have Datverse tables created in my power apps solution and i want to view these tables na dthe views of these tables that i created in SSMS so that i could calculations and logics in SSMS
Even though i can view the tables by connecting to the Power Apps environment using it as a Datbase engine is SSMS.
However, i am not able to see the views i careted for these table sin SSMS or even in Azure Data Studio.

I tried creating new tabels and views and even loading tables from new Environmnets nothing seems to work to show up the views in SSMS or any other Database Engine for that matter.

Can someone help me with this.
Any Help would be appreciated.

Many Thanks
Sai

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Did you verify that you have the permissions necessary to see them, using how you are connecting in SSMS?

Are you not able to see ANY views or just the view you created. I would verify the roles etc you have based on the account connecting with SSMS.

Was this reply helpful? Yes No
Sai97 17 on at

Like (0)

Report
Copy link

Link copied!

Hi FLMike,

Thanks for the response yes i do have Admin permissoins in the Power apps environment and still not able to find any views in SSMS (the default ones or even the ones I created)

I would appreciate if you or anyone in the comunity could show me a screenshot of the Power apps dataverse table views in SSMS or Azure Data studio for that matter as a proof of concept for me to get confidence on it please.

Many Thanks
Sai

Was this reply helpful? Yes No
Suggested answer

timl 36,774 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Sai97

Unfortunately this is not possible.

As per the documentation, you can access the tables (which is what you're seeing), but "no custom views of the data are provided.".

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query

Was this reply helpful? Yes No