Programmatically create table visual from dataset and get embed dashboard url

[duncan]

Hello @zhan2819 !

To do this effectively and automatically you will need to create permissions and most likely a lambda function but the general outline is that you will need to create a version of the analysis that you want to publish as your dashboard and use that as a template. From there you can use APIs to make updates. I would recommend checking out the following:

CreateDataSet - Amazon QuickSight
UpdateAnalysis - Amazon QuickSight
GetDashboardEmbedUrl - Amazon QuickSight

I would also check out this topic:

How to edit published dashboard created from a template and make change available with boto3?

You can save a new analysis from the dashboard, make changes to it and then publish a new dashboard. When you publish, you won’t see the option to replace the original. [image] If you really need to replace the original dashboard instead of creating a new one, I think there may be a way with the API but I haven’t tried it myself. After you save the new analysis from the original dashboard, use it to create a template by specifying it as the source analysis in the request body. [image] T…