Filter Model Driven Data more easily with the AI Data Exploration Agent

The new Data Exploration Agent in Power Apps is an AI feature for Model Driven apps which allows users to search for data using natural language. A nice thing about it is that it provides AI charting capabilities, which provides simple charts out of the box.

If you've not yet seen this feature, here's a quick walkthrough of how this works.

Getting started with the Data Exploration Agent

The first step is to enable this feature in the Power Platform Admin Center (PPAC).

In PPAC, select Environments from the left-hand menu and select your target environment.

Next, click the Settings cog in the header. Go to Settings > Product > Features.

At the bottom of the features section, you'll see a Natural Language Grid and View Search item. Choose the option to 'Enable this feature'. As shown below, I enabled it for 'all users immediately'.

Using the Data Exploration Agent

To test this feature, I used the animal shelter demo data from the PowerUp program. This includes an "Animals" table for a pet shelter. The table includes various records of animals, such as their names, species, ages, and adoption statuses. 

Once the feature is enabled, a natural language search box appears in the header. From here, I can type a natural language query like "Show me all dogs available for adoption". We see a slight delay as the query is built as shown below.


Shortly after, the results are shown. With this example, animal type is a lookup column so the query manages to recurse the relationship. 

If we then click the 'visualize' button, an autogenerated chart. The customisation options are a bit limited. Beyond changing the chart type and saving it, there isn't much more we can do. However, it suffices as a quick visualisation.


Conclusion

The Data Exploration Agent is a great addition that makes it quicker and easier to filter table in model driven apps. It's great to see these AI features being introduced in the product.

Related posts

Dataverse - How to set yes no values with checkbox- Walkthrough
January 29, 2025
Dataverse - Add image column missing when creating table - how to fix
January 19, 2025
Data - How to view the progress and status of a Dataverse CSV/Excel Import
January 15, 2025
Error - Diagnosing the error "Network error when using the Patch function" when saving data with a form
May 05, 2024
Dataverse - How to work around the error "multiple levels of many-to-one relationship expansion aren't supported"
April 05, 2024
Dataverse - The easiest way to modify Dataverse data outside of Dataverse and Power Apps
February 18, 2024
Dataverse - How to use a checkbox control a set a yes/no field in Dataverse
July 10, 2023
Dataverse - How to create Entity Relationship diagrams
January 22, 2023
Dataverse - How you can more quickly bulk update data using the SQL language
January 14, 2023
Dataverse - How to fix the bug in the 'Business Rules' editor that prevents numeric values from saving
January 05, 2023
Dataverse - What are the benefits, and how to create formula columns
July 20, 2022
Dataverse - How to sort the available choice items from a choice column
May 12, 2022
Error - Unable to modify Dataverse tables with error message, Language id should not be null
September 27, 2021
Dataverse - How to retrieve FetchXML or SQL for Dataverse views
July 13, 2021
Data - Why is Dataverse so fast?
June 15, 2021
Dataverse - How to create and use Dataverse views in Canvas Apps
June 09, 2021
Dataverse - How to filter Dataverse choice columns
June 07, 2021
Dataverse - How to switch to the classic designer when the option is not available
May 26, 2021
Licensing - What are Dataverse Restricted tables?
March 26, 2021
Media - How to save and work with microphone recordings
March 09, 2021
Dataverse - how to access tables from another environment
February 23, 2021
Dataverse - How to Patch the 5 most complex data types
January 19, 2021