Launching QS pannel using GenerateEmbedUrlForRegisteredUser API takes too long

Hello

We have designed a panel for registered users which is driven by “used-based rules”. The panel works fine if we access it via the Quicksight login site with the registered users, but we would like to include a link in our external system (CRM) that will launch the pannel in a new window of the browser using the “GenerateEmbedUrlForRegisteredUser” API.

The URL produced by the API launches the pannel ok, but the problem is that takes really a long time (1,5 mins average) loading before any data is shown. Once the panel is loaded you can play with the filters and see the data fine, but the time it takes to load is not acceptable for an user to wait until he sees the information.

As I said, this does not happens if you access the Quick Sight panel using the login site, selecting the panel… information is shown in 1 or 2 seconds.

We build the query introducing this information

quicksight:
accountId: ‘ZZZZZZZZZ’
dashboardId: ‘value_Dashboard_ID’
allowed-domains: ‘https://eu-west-1.quicksight.aws.amazon.com
namespace: ‘MyNameSpace’
username: ‘quickdev’
access-key-id: ‘value-access-key-id’
secret-key: ‘SECRET’

To produce this URL

https://eu-west-1.quicksight.aws.amazon.com/embed/00ff31b34b7b4c5f932ece2979ab1ae2/dashboards/d8ecaa00-8484-497b-99ff-8414ca975bcb?identityprovider=quicksight&isauthcode=true&code=AYABeIJDrBh7-b4L4-azT70n268AAAABAAdhd3Mta21zAEthcm46YXdzOmttczpldS13ZXN0LTE6MzU2MzA1MTgzMDczOmtleS83ZTYwMTNkMC0xM2I0LTRmODItYmI1NC00YjllMTM4NzczNjYAuAECAQB4oLaTKALZYrODT8vppyXY_wi1QN4BvYbJQ0MfnXuTFjoBxO5aJx1DSnwg3PIvKuZzeQAAAH4wfAYJKoZIhvcNAQcGoG8wbQIBADBoBgkqhkiG9w0BBwEwHgYJYIZIAWUDBAEuMBEEDG2KxHKRo63IQT_y1AIBEIA7py4oEChd-aYPtFZGYyQGoRx6YUiuJ5bagk18YYbccVy4O79fg5fzv5HVlXoCEA04-_Clz41kLyK7ogwCAAAAAAwAABAAAAAAAAAAAAAAAAAAcW5wZ5LX1J12izvnt3KYtv____8AAAABAAAAAAAAAAAAAAABAAAAmwdJvGlAkaewUpLJ_OBX4Wa2SdKdLBYVgUCgTBG-pDzlOScE7cWE_Z0Uiah5VjxRiIk9KLJfTXSxFtKSLrKhAhWpNWGBw1oLcvoC2off4Fv4s8xMpY8iU8roJfGquEaldLicCqxANHnrCEA8o6osggXrTPfzCtcQpSo7ZRX8p5wtQGY8YF37nUIhuPptTMZuOaZHZaqn0S61DpCOcl94I_bkfAODMyxBtyHItw%3D%3D

Any idea of why this panel can take so long to display the information, or what can we do to speed this time up?

Thanks a lot in advance

Hello @Jlabuelo

Are you using SPICE or direct query? Also, for the dataset, are you doing calculations on the analysis layer or on the data prep layer, and how complex are you calculations?

The reason I ask is those are the primary ways that you can speed up loading data into a dashboard.

Here’s another good post on this issue:

Hey @Jlabuelo

Do you still need help with this, and were you able to look into the items I mentioned above?

Hello Duncan

Sorry, I got QS mail in Spam and this is why I could not answer you before.
We are using a Panel with 4 Sheets, and these sheets uses also two different DataSets
Both DatSet1 & DataSet2 are both Spice DataSest filtered with used-based rules.

We have some Calculated fields in these sheets, but with basic calculations like “(a+b)/c” or counters.

What it is strange is that if I access the panel using the QS site, it works fine, but launching it with this URL generated it is when it takes too long.

Hi @Jlabuelo,

Are you still encountering the same issues or were you able to deploy a work around that helped speed up this process?
Take a look at the attached article that explores various ways to help with data flow:

If you continue to encounter these delayed load times that aren’t taking place directly in QS, I would consider filing a support case to get more direct assistance from AWS support team.

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

Hi @Jlabuelo,

Since we have not heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!