Actions on visualizations (charts)
Using the Microsoft Dataverse Web Services, you can perform the following actions on the visualization tables.
Actions on organization-owned visualizations
To perform actions on an organization-owned visualization (SavedQueryVisualization
), you must have the System Administrator or the System Customizer role. You can perform the following actions on an organization-owned visualization:
Create, retrieve, update, and delete an organization-owned visualization. More information: Create a visualization
Note
After updating an organization-owned visualization, you must publish the table definitions changes to make it visible across the organization by using the PublishAllXmlRequest message. Alternatively, whenever you publish a table, all the unpublished organization-owned visualizations that are attached to the table are published automatically.
Query and retrieve all the organization-owned visualizations that are attached to a table using the
SavedQueryVisualization.PrimaryEntityTypeCode
. Multiple organization-owned visualizations can be attached to a single table. For a list of tables with which you can attach a visualization, see Tables Supported for visualizations. For a code sample that demonstrates how to retrieve all the organization-owned visualizations attached to a table, see Sample: Retrieve all charts attached to a table.Note
You cannot change or update a visualization to attach it with a different table after you have created the visualization. It implies that the
SavedQueryVisualization.PrimaryEntityTypeCode
is not valid for the update action on the organization-owned visualization.Specify an organization-owned visualization as the default visualization for the associated table by setting the
SavedQueryVisualization.IsDefault
totrue
. When you set an organization-owned visualization as the default visualization for a table, the visualization is displayed by default when you select to view the visualizations for this table in Dataverse.Note
Using the Dataverse Web Services, if you set an organization-owned visualization as default for a table that already has another visualization set as default, both the visualizations are marked as default visualizations for the table. To set a visualization as a default visualization for a table, make sure that no other visualization is set as the default visualization for the table.
For a list of supported messages on the organization-owned visualization table, see SavedQueryVisualization table.
Actions on user-owned visualizations
You can perform the following actions on a user-owned visualization (UserQueryVisualization
):
Create, retrieve, update, and delete a user-owned visualization. More information: Create a visualization
Query and retrieve all the user-owned visualizations that are attached to a table using the
UserQueryVisualization.PrimaryEntityTypeCode
. Multiple user-owned visualizations can be attached to a table. For a list of tables with which you can attach a visualization, see Tables supported for visualizations.Note
You cannot change or update a visualization to attach it with a different table after you have created the visualization. It implies that the
UserQueryVisualization.PrimaryEntityTypeCode
is not valid for the update action on the user-owned visualization.Change the ownership of a user-owned visualization by assigning it to another user or team using AssignRequest.
Retrieve the access that the specified security principal (user or team) has to a user-owned visualization using RetrievePrincipalAccessRequest. You can also retrieve all the security principals (users or teams) that have access to a user-owned visualization, along with their access rights to the user-owned visualization using the RetrieveSharedPrincipalsAndAccessRequest.
Collaborate with other users and teams on specific areas by sharing a user-owned visualization with them using GrantAccessRequest, ModifyAccessRequest, and RevokeAccessRequest.
For a list of supported messages on the user-owned visualization table, see UserQueryVisualization table.
See also
Charts
Understanding Charts: Underlying data and chart representation
Create a chart
Sample charts
Sample: Create, retrieve, update, and delete (CRUD) a chart
Sample: Retrieve all charts attached to a table
Sample: Assign a chart to another user
SavedQueryVisualization table
UserQueryVisualization table