web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Engage with the Community
Suggested Answer

Power CAT Code Review Results Not Persisting to Dataverse Tables

(1) ShareShare
ReportReport
Posted on by 2

Hi Team,

We are a DevOps team currently evaluating Power CAT Tools in a test Power Platform environment.

We installed the tool from Power Platform Admin Center (AppSource) and are able to successfully run Code Reviews against unmanaged solutions. The review completes successfully and the results are displayed correctly in the Power CAT UI, including:


  • Status

  • Review at a Glance

  • Fail Severity

  • Detailed Findings

  •  

However, we are unable to determine where the review results are being persisted. According to the Power CAT documentation and data model, review-related information appears to be stored in Dataverse tables. We can see the following tables in our environment

cat_solutionreview
cat_patterndetails
cat_patternresult
cat_solutioncomponent

After executing multiple reviews, we do not see any new records being created or existing records being updated in these tables. The review results are visible in the UI, but we cannot locate the underlying data. The Power CAT documentation also references older table names such as cat_review, cat_reviewapp, cat_reviewpattern, and cat_reviewpatternresult, but those tables do not exist in our installation.

We would appreciate clarification on the following:


  1. Which Dataverse tables are currently used by the latest Power CAT release to store:


    • Review Status

    • Review at a Glance

    • Fail Severity

    • Detailed Findings
  2. Have the original review tables been renamed in recent releases?

  3. Are there specific security privileges required for review results to be written to these tables?

  4. If review data is persisted, is there a supported way to retrieve the results programmatically (Dataverse Web API, PowerShell, Power Automate, etc.)?

  5. If the results are not stored in Dataverse, how does the Power CAT UI populate the review summary and findings displayed to users?

 

Any guidance on the review result storage mechanism and required permissions would be greatly appreciated.

 

Thank you.

 
  • Suggested answer
    11manish Profile Picture
    4,792 Super User 2026 Season 2 on at
    Power CAT Tools currently uses the newer cat_solutionreview, cat_solutioncomponent, cat_patternresult, and related pattern tables rather than the older cat_review* tables. Microsoft introduced new tables in the March 2025 release because of a Dataverse Accelerator table conflict. The old and new table models should therefore not be treated as equivalent without checking the installed version.

    The fact that Code Review results appear in the Power CAT UI does not by itself prove that every displayed value is persisted as a Dataverse record. First validate persistence using a System Administrator account and inspect the current cat_* tables immediately after a new review. There is also documented evidence of missing Create privileges for cat_solutionreview, so security privileges should be explicitly checked.

    If records are created for System Administrator but not for the DevOps user, the issue is security/privilege configuration. If no records are created even for System Administrator, this should be treated as a Power CAT implementation/version issue and raised with Microsoft rather than attempting to recreate the review logic externally.
  • PS-10091406-0 Profile Picture
    2 on at
    Hi @11manish,

    Thanks for the suggestion. We verified the permissions and tested using a System Administrator account as well. The Power CAT review runs successfully and the results are visible in the UI, but no records are being created or updated in the expected Power CAT Dataverse tables. Therefore, this does not appear to be a security role or table permission issue.
     
    Could you please advise where we should raise this issue with the Power CAT product team?
     
    Is there a preferred support channel for issues related to review result persistence and Power CAT Dataverse tables in the latest release?

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Engage with the Community

#1
M Bilal Khan Profile Picture

M Bilal Khan 30

#2
Mohsin Ali Profile Picture

Mohsin Ali 28

#3
11manish Profile Picture

11manish 16 Super User 2026 Season 2

Last 30 days Overall leaderboard