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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 117 Super User 2025 Season 2
MVP-Daniyal Khaleel 115
Erin Lubben 66
