Announcements
No record found.
Hi Experts,
Is it possible to access POA Table in CRM online from console application or any other means to check the records?
Thanks,
Saqib
Hello Saqib,
We can access the POA Table properties using Web API.
[organization URI]/api/data/v9.0/principalobjectaccessset
Please refer this articles:
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/principalobjectaccess?view=dynamics-ce-odata-9
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/principalobjectattributeaccess?view=dynamics-ce-odata-9
Also if you have Data Export Service feature enabled and you can directly Query Azure SQL DB to access POA records.
https://docs.microsoft.com/en-us/power-platform/admin/replicate-data-microsoft-azure-sql-database
https://community.dynamics.com/crm/b/cinterosab_crmblog/posts/principal-object-access-table-poa-table-grows-large
Hope this helps.
Best regards,
Sumeet_MSFT
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Hi,
New feature introduced where you can directly query CDS DB using sql .
See below post
xrmdynamicscrm.wordpress.com/.../
In addition to what has already been said, you can also try with this XrmToolBox plugin, which has a user-friendly interface and makes it easy to have a sneak peek at those records:
https://www.xrmtoolbox.com/plugins/Ameed.Xrm.SearchPOALandscape/
https://ameedsheikh.wordpress.com/2017/04/19/search-shared-data-across-crm-entities/
Hope it helps,
Marco
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
ManoVerse 196 Super User 2026 Season 1
11manish 129
CU11031447-0 100
