I am doing an impact analysis related to a dataset that requires a major change. So, I wanted to get the details of the usage of this dataset in the various dashboards.
The usage tab displays the list of analysis/dashboards but does not have a download option. I find this same situation in a lot of the admin pages (User List, Manage Assets list etc). If there is a list there should be an option for an easy download/export as well.
Going to CLI for each small thing is not a good idea.
Currently, there is no direct download or export option for the dataset usage information in Amazon QuickSight. You can view which dashboards and analyses use a dataset by navigating to the Datasets page, selecting your dataset, clicking Edit dataset, then choosing Manage > Usage.
This manual process shows the list of analyses and dashboards using the dataset, but lacks an export functionality. Link
For programmatic access to this information, there is no single API that provides dataset usage details. Combining multiple API calls such as ‘list_data_sets’, ‘list_analyses’, and ‘list_dashboards’ could be helpful
Another recommended approach is deploying the Admin Console dashboard, which provides insights into dataset relationships with analyses and dashboards. [Link]
This solution includes a Data Dictionary sheet that details asset relationships between datasets, analyses, and dashboards.