Questions tagged with Amazon QuickSight

I have a public, static website where I want to display embedded QuickSight charts. My data are in s3. I estimate the site will display around a dozen or so charts sprinkled across a few pages. The site is initially a low traffic site, starting at around 50 unique views per day with it hopefully eventually ramping up to 1000 views plus per day. I am the only developer. I'm confused with the pricing model listed in the official [pricing page](https://aws.amazon.com/quicksight/pricing/). I have the following questions: 1. Do public embedded charts and/or dashboards require me to choose the enterprise edition? 2. Is QuickSight really built for public access? Does each unique visitor count as a "reader?" 3. If the answer to the second question on #2 is yes, does this mean each visitor initiates a session? 4. Is QuickSight even appropriate for my use case?

Hello, due to the following Step by Step Guide provided by the official AWS Athena user-guide (Link at the End of the question), it should be possible to connect Tableau Desktop to Athena and Lake Formation via the Simba Athena JDBC Driver using Okta as Idp. The challenge that I am facing right now, is although i followed each step as documented in the Athena user-guide i can not make the connection work. The error message that i recieve whenever i try to connect Tableau Desktop states: > [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. The security token included in the request is invalid. [Execution ID not available] Invalid Username or Password. My athena.properties file to configure the driver on the Tableau via connection string URL looks as follows (User Name and Password are masked): ``` jdbc:awsathena://AwsRegion=eu-central-1; S3OutputLocation=s3://athena-query-results; AwsCredentialsProviderClass=com.simba.athena.iamsupport.plugin.OktaCredentialsProvider; idp_host=1234.okta.com; User=*****.*****@example.com; Password=******************; app_id=****************************; ssl_insecure=true; okta_mfa_type=oktaverifywithpush; LakeFormationEnabled=true; ``` The configuration settings used in here are from the official Simba Athena JDBC driver documentation (Version: 2.0.31). Furthermore i assigned the required permissions for my users and groups inside Lake Formation as stated in the Step by Step guide linked below. Right now I am not able to point out why I am not able to make the connection work. So I would be very greatful for any support / idea to find a solution on that topic. Best regards Link: https://docs.aws.amazon.com/athena/latest/ug/security-athena-lake-formation-jdbc-okta-tutorial.html#security-athena-lake-formation-jdbc-okta-tutorial-step-1-create-an-okta-account)

We are looking to expand services via AWS Quicksight, our use case would include Amazon subsidiary users who can be both in Amazon network and not. My question is it possible to setup new AWS accounts to allow BOTH Active Directory (for in network users) and unique IAM roles (for subsidiary/off-network users)? If not what are the options to allow this type of access using SSO where possible.

hello, I've been trying to get QuickSight to parse one CSV document I have, and it's not working. It keeps telling me that the format is not supported and the file cant be parsed although it's a normal CSV file. Any suggestions regarding this?

I am trying to copy a cross-source dataset to another account using the JavaScript SDK. For single-source datasets this works fine, however am struggling to get it working with cross-source data. Copying involves describing the dataset on one account and using the returned parameters to create the dataset on another. An example - The dataset I'm trying to copy is created using an outer join on two S3 based datasets, called 'trends' and 'aggregated'. The dataset's PhysicalTable is taken from the S3 datasource of the 'trends' data. When we describe the joined dataset we receive two LogicalTableOperations, one (presumably) linking the aggregated set and the other doing the join operation. The JSON for the linking operation looks like this: ``` "Alias": "aggregated", "DataTransforms": [ { "CastColumnTypeOperation": { "ColumnName": "percent", "NewColumnType": "DECIMAL", "Format": null } } ], "Source": { "PhysicalTableId": null } ``` When this is piped into the create stage of the copy it errors during `createDataSet` as `PhysicalTableId` can't be null. I already have the aggregated dataset on the second account and I have tried playing around with the `DataSetArn` parameter in `Source`, but that leads to another error saying it is an Unexpected Key. Does anyone know how can I link it to the new dataset using the sdk? There is absolutely zero information online about this and I am going postal.

I am new to create calculated fields with the Quicksight. I have some dataset with the resolved tickets information which needs to be shown with the tag and with the week of the year. Is it possible to show through table ? Example ) I have 10,000 resolved tickets for each week which needs to show through week numbers only and with the selected tag with the ticket. I have access to the dataset but unable show the same through Week numbers

I have created an Html page in an s3 bucket and made the bucket public. when I tried embedding the quicksight dashboard in the Virginia region, it all works seamlessly. But the same thing when I created the s3 bucket, API gateway, and lambda in the London region, I am getting the below error in the iframe. **Refused to frame 'https://eu-west-2.quicksight.aws.amazon.com/' because an ancestor violates the following Content Security Policy directive: "frame-ancestors** Can anyone assist me with this?

I am trying to show data on AWS Quicksight which iot simulator generated. But I can't find data in S3. Someone Please show me where the data is stored,and the name of the file.

How can I setup the datapipeline to help us setup a way to query 30-60 like databases. Currently we are using a connector to replicate data from all our locations to RDS MySQL db. We are wanting to use Quicksights to query Sets of data from all the RDS Sources brought into the RDS MySQL db. Would love some guidance on how we can accomplish this. I appreciate all of you brilliant people out there

My data contains 3 columns with dates using this format: ``` 2022-01-01T12:47:33.116+00:00 ``` I have about **27 million rows** within a **dozen or so CSV files in S3** that I want to import. The import fails so I then **mark the 4 columns as strings** for a successful import. I cannot have the source change the format of the dates. Can someone please tell me what the simplest thing I can do to import the dates into SPICE as dates without modifying the source CSV data? I appreciate any help and your input. Thank you. -Ajay

We have one dataset which is extracted from redshift We are using that dataset to publish our dashboards but it's saying visual error on the dashboard and it's not able to load all the data * We are using Direct Query mode for the dataset * If we do change query mode to SPICE it works fine Please see attached ss

Hi, Is there a way to use the contents of a specific field in timestream data for the title of a visualization scatter graph in quicksight? Thanks Mike

When I clicked the dashboard link, it took me to the QuickSight default home page (not the dashboard view). If it's an access issue, I'd expect an error message indicating "no access", however there's no error returned and that's why I'm confused. Could anyone help me figure this out? Thanks!

Hello. I'm trying to create an analysis from my DocumentDB instance. I'm using the aws services Glue, Athena and Quicksight. In Glue I have created a connection to the DocumentDB and a crawler for auto creating tables. This works as expected and tables are created and displayed in glue. Even though I specify that the crawler should not give the tables any prefixes, it does add the database name as a prefix. When I look at the Glue catalog in Athena (the default AwsDataCatalog) I do see the database that was created in glue, however it does not show any tables. If I click on edit, it takes me to the correct database in glue which displays the tables that have been created by the previously mentioned crawler. So my first question is **Why doesn't the tables show up in Athena?** This is blocking me from performing queries in Athena. When I go to QuickSight and select the default Athena glue catalog ("AwsDataCatalog") I DO get the tables created by the crawler, and I can create datasets. However, when I try to create an analysis using these datasets, I get the error: ``` sourceErrorCode: 100071 sourceErrorMessage: [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. HIVE_UNSUPPORTED_FORMAT: Unable to create input format ``` I have looked a bit around and some people said that this error is due to the table properties **"Input format"** and **"Output format"** being empty (which they indeed are for me). I have tried entering almost all the different formats to the table, but I keep on getting the Quicksight error above only now it has the input format at the end ``` HIVE_UNSUPPORTED_FORMAT: Unable to create input format json ``` **So my second questions is** I do not see anywhere in the crawler where I can specify input or output format. Does it have to be done manually? And What are the correct input and output formats for my setup?

I am trying to find a way to embed a quicksight dashboard into a WIKI page. I know I can hyperlink to it, but really want it to embed and show a live view of the dashboard. The dashboard is a shared dashboard that AMZL uses for daily DBR.

Hi, I'm trying to find a way to embed a dashboard that only shows data that is allowed on a per client basis. These clients are users of our platform and as such do not have separate incognito or iam accounts, they are simply user records in our database. Is there any way to generate a dashboard URL that enforces the data query to be subset by parameters that are not exposed to the web browser client (and so could not be modified by changing client side javascript or url querystring)? Thanks, Mark.

We're using AWS QuickSight with Google SAML. For some users it's working fine but for others we're seeing below error. Any help would be appreciated. ``` You don't have permission to view this page. Contact your QuickSight administrator to request permission. ``` For more information, earlier we were using normal AWS IAM users to login into QuickSight and we recently moved to Google SAML login. Thanks and Regards.

I have a Athen data source which is a documentDB service. I have successfully managed to connect the two, and can perform SQL queries to the database from Athena and get data. The results are added to an S3 bucket. I want to use QuickSight to visualize Athena queries. However, I'm running into a TIME_OUT error when trying to create a Athena data set in Quicksight. Quicksight manages to connect to Athena and SSL validation works. When I click "Create data source" I'm set to the next step where I can select both the catalog and (DocumentDB) database. But the table selector view is timing out, which blocks me from creating the data set. So my questions is, why would it time out?

I have been using QuickSight for a while. I am importing data from Athena and RDS into Spice and building reports on them. I am now being told in the QuickSight console that my Spice Capacity is full - apparently I am using 320GB of data. However, when I look at all my data sets, the sizes only add up to about 20GB, so I've no idea how I've hit 320GB. Is there some way I can see the Spice usage breakdown? Or could there be some hidden old versions of data that it is holding onto?

When joining 2 pre-existing datasets where at least 1 is spiced, the resulting 3rd dataset automatically defaults to be spiced also, with no apparent way of changing this. is this the expected behaviour? The datasets are all from the same data source. This results in the data in the parent dataset that is spiced being also spiced in the child dataset, resulting in a double charge for this data. If this is correct, are there any plans to change this, so that the customer only pays for the same data once?

Does QuickSight provide a way to filter a direct query running against a database, based on filters selected by the user when the report is run? We have a report that needs to return financial balances for a period of time, based on the filters that a user chooses. So, if the user chooses a specific date, we would be expected to show a balance for that date and for 4 weeks previous, 8 weeks, 12 weeks etc. The only way we can achieve this currently is to have the balance for every single date for the last few financial years returned by our custom SQL query, for each separate account. This results in millions of rows needed in the dataset to cater for every filter date that the user may choose. The query also takes a long time to run because of this. If the answer to this question is no, would this be something that may become available in the future please?

Hello! I have an analysis in Quicksight with two tabs - one is an "overview" tab where we look at all of our units, and then there's a "deep dive" tab where it gives more detail about a single unit. The "overview" tab has a table where it lists all of the units and various metrics for them. I want to be able to click on a row in that table, and have it take me to the "deep dive" tab. When it goes to the deep dive tab, I want it to fill in a couple controls on the new tab (like the unit serial number) so that all the visuals filter by that serial number, and the tab is showing me just information about this specific unit. It seems like a Navigation Action with updating parameters is the way to go, but it doesn't work. When I click on the row I want (both in the analysis and the dashboard), it takes me to the deep dive tab, but it doesn't fill in the controls, so they still display "all". it seems like this is not the functionality intended. In the "Action" tab for the visual in the "overview" tab, I have selected the following options: Activation: "Select" Action Type: Navigation Action Target Sheet: deep dive tab Parameters: Here I have listed the parameters I want to fill, and the fields that correspond to them. Again, when I click on the row, it takes me to the new tab, but it doesn't fill in the parameters. Is this a bug or is this as intended? If it's intended, how do I make it so users can click on a row and it takes me to the deep dive tab and fills in the controls so that the visuals filter by the control values?

I have a dashboard and I do not want to have any access restrictions for Amazon employees. Is it possible? any ANT group that provides access to all Amazon employees?

Is it possible to plot X-Axes values in SignalX_Sampled_messsignal and Y-Axes values in SignalX_Sampled_zeitvektor) in QS Data example: ``` SignalX_Sampled_messsignal,SignalX_Sampled_zeitvektor [47.5, 47.5, 47.5, 47.5, 47.5, 47.5, 47.5, 47.5, 47.5],[-1016, -816, -616, -416, -216, -16, 184, 384, 584] [26.25, 26.25, 26.25, 26.25, 26.25, 26.25, 26.25, 26.25, 26.25],[-1015, -815, -615, -415, -215, -15, 185, 385, 585] [18.25, 18.25, 18.25, 18.25, 18.25, 18.25, 18.25, 18.25, 18.25],[-1045, -845, -645, -445, -245, -45, 155, 355, 555] [79.75, 79.75, 79.75, 79.75, 79.75, 79.75, 79.75, 79.75, 79.75],[-1045, -845, -645, -445, -245, -45, 155, 355, 555] [7.75, 7.75, 7.75, 7.75, 7.75, 7.75, 7.75, 7.75, 7.75, 7.75],[-1076, -876, -676, -476, -276, -76, 124, 324, 524, 724] [26.75, 26.75, 26.75, 26.75, 26.75, 26.75, 26.75, 26.75, 26.75],[-1006, -806, -606, -406, -206, -6, 194, 394, 594] [13.75, 13.75, 13.75, 13.75, 13.75, 13.75, 13.75, 13.75, 13.75, 13.75],[-1144, -944, -744, -544, -344, -144, 56, 256, 456, 656] [67.75, 67.75, 67.75, 67.75, 67.75, 67.75, 67.75, 67.75, 67.75],[-1046, -846, -646, -446, -246, -46, 154, 354, 554] [43.25, 43.25, 43.25, 43.25, 43.25, 43.25, 43.25, 43.25, 43.25, 43.25],[-1127, -927, -727, -527, -327, -127, 73, 273, 473, 673] [22.5, 22.5, 22.5, 22.5, 22.5, 22.5, 22.5, 22.5, 22.5],[-1046, -846, -646, -446, -246, -46, 154, 354, 554] [25.75, 25.75, 25.75, 25.75, 25.75, 25.75, 25.75, 25.75, 25.75],[-1044, -844, -644, -444, -244, -44, 156, 356, 556] [25.75, 25.75, 25.75, 25.75, 25.75, 25.75, 25.75, 25.75, 25.75, 25.75],[-1066, -866, -666, -466, -266, -66, 134, 334, 534, 734] ```

Imagine if we have a time series values like this, lets say the timestamps are in epoch and device is emitting a payload every minute. |timestamp| device| sensorName| sensorValue| |---|---|---|---| |1612828800001| device1| mode | Running| |1612828800001| device1| fuelUsed |23| |1612828800011| device1| mode | Running| |1612828800011| device1| fuelUsed |33| |1612828800021| device1| mode | Running| |1612828800021| device1| fuelUsed |50| |1612828800002| device1| mode | Not Running |1612823800002| device1| fuelUsed | 45| |1612828800002| device2| mode | Running| |1612823800002| device2| fuelUsed | 77| And we would like to know what was the TotalfuelUsed in the last 30 days when the mode was Running (mode Not Running means engine is on but not moving = idle). We tried using calculated field and periodToDateAvg function but somehow it is just not possible to do this complex query in one or multiple calculations * Calculated Field 1: Productive Productive time = sum(periodToDateAvg({sensorName} = 'mode' and {sensorValue} = 'Running', Month )) <<<---- Need help here * Calculated Field 1: TotalFuelUsedDuringProductive TotalFuelUsedDuringProductive = TotalFuelUsed/Productive * Expected Output device1 TotalFuelUsedDuringProductive = (50-23)/(3-2) Is this even possible to do in Quicksight? or do we have to use Athena SQL Query?

I have a cron job that exports a list of number of messages per user frequencies such as: * 10 * 1 * 5 * 2 * 8 * 3 (Which means: 8 users have posted 3 messages) I'd like to have a histogram chart which displays last snapshot's data (ie. bar, mean, avg). I was thinking of TimeStream, but it actually accumulate. What is the recommended storage for this usecase?

I have an AWS TimeStream table defined as follows: * user_id (varchar) * measure_name (varchar) * time (timestamp) * measure_value::boolean (boolean) (`measure_name` being an event name) When I imported it in QuickSight however I only get the mesure in the fields list, not the dimension: * measure_name * time My goal is to have charts of the number of unique users per day for example. How can I import the dimensions from TimeStream?

Dataset is not loading data on schedule /manual refresh . Rows Ingested 0 , rows dropped 0. but query returns data in database. No error message in quicksight

Hello quicksight community, i am trying to freeze the first column in a table view within quicksight and am unsure how to do this. I do not see any simple option of doing so, so i am hoping someone can provide a possible workaround here for me? Basically, i want to scroll right to left and the very first column which is an identifier/group by column, stays frozen so we know what data we are looking at as scrolling right to left. Thanks in advance.

Hi, I am trying to display the dashboard I have created on QuickSight to a webpage. I have published the dashboard and used the 'Copy Embed Code' option to copy the URL to the html page. I am getting the error 'us-east-1.quicksight.aws.amazon.com refused to connect.' Is there anyway to make the URL work in the html page?

I have the following Calculated Field periodOverPeriodDifference(sum(test), createdAt) where the current output in a pivot table looks standard with createdAt as Rows and other CalculatedFields calculating the YOY Growth and Total Growth. However every time I add the above CalculatedField in I am met with a SQL Exception but I cannot see the error.

I created a Athena data source connector, which can query dynamodb data successfully. However, when I tried to create a new dataset in QuickSight with Athena, it can NOT see my 'data source connector'? Do I miss anything? Thanks!

I have QuickSight and an RDS(postgres) instance, both in the same region (US-West-2). I also have a valid VPC Connection (checked in the "Reachability Analyzer") between my QuickSight ENI and the RDS ENI. My Goal is to connect QuickSight to the RDS DB, so I can use the DB as a QuickSight Data Source. However, when I go to create a dataset in QuickSight, I am unable to validate the connection. The error I get back is a Postgres authentication error (copied below). I've verified that: - The VPC Connection is valid - The DB username/password is correct - Security Groups are configured as specified in AWS Documentation (gone over these multiple times) - I can interact with the DB otherwise (via application) Error message after failed connection validation: ``` The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver. ```

Hi All, I have access to the dataset of around 2 years of Data. I am trying to truncate the information only specific to the weekly data from it.I have tried truncate date to take only the data specific to the last week but its not working .Let me know the calculated fields to be used in the quicksight to update the automatically each week. The data will be changing automatically in the back end

I would like to create new Quicksight Analysis & Template in CDK (python): I'm trying to do it with [CfnAnalysis ](https://docs.aws.amazon.com/cdk/api/v1/python/aws_cdk.aws_quicksight/CfnAnalysis.html)class & [CfnTemplate](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-quicksight-template.html) the problem is with SourceEntity parameter in both classes. Both of them required to provide arn of each other, but during CREATE_IN_PROGRESS only one of them is ready, so I get an error "Resource of type 'AWS::QuickSight::Analysis' with identifier 'CfnAnalysisId' was not found." I can skip in CfnTemplate parameter SourceAnalysis and give instead SourceTemplate with arn of existing template but then when I try to use this template to create a Dashboard I receive another error: "Given placeholders [placeholder] are not part of template". This is correct but placeholder parameter is part of "SourceAnalysis" parameter so back to the original problem. In conclusion, I would like to use CDK to create a new template and a new analysis, both objects need each other, so how can this be done?

Hi All, I use Quicksight Embed for my customers. Everything has been working perfectly, but all customers are down as of this morning and receiving this error message "fips-us-east-2.quicksight.aws.amazon.com refused to connect." Is there a way for me to test to see if the issue with with the API?

I've generated an API token for our Jira board on our Atlassian account. After going on [New Dataset] -> [Jira] in QuickSight, the connection is validated after entering the API token. But this message appears even though I am an admin: "The SaaS isn’t available. The URL might not be accessible, or the instance might not be available. You can check the service and try again. Contact your data source administrator for assistance."

I am using boxplots in AWS QuickSight. When I tick "Show outliers" under "Format visual", not only the outliers are shown, but also the shape of the boxplots change. 1. Are the calculations of the boxplots different when selecting "Show outliers"? 2. How is an outlier defined by QuickSight? And can I change this outlier definition?

Given specific geospatial points for a route (e.g. a flight route), can we show the route on a map through Quicksight? (similar to what can be done in plotly: https://medium.com/technology-hits/working-with-maps-in-python-with-mapbox-and-plotly-6f454522ccdd)

My company's Fiscal year starts from April to next March and we calculate sales data according to fiscal year. Is there anyway to change the date into Fiscal Year in Quicksight?

[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. Row is not a valid JSON Object - JSONException: Expected a ',' or '}' at 149 [character 150 line 1] [Execution ID: fd5f862a-7558-4329-93df-08ba753e7ee1]

HIVE_PARTITION_SCHEMA_MISMATCH: There is a mismatch between the table and partition schemas. The types are incompatible and cannot be coerced. The column 'attributes' in table 'clickstream-ctr-database.care_events_dev1' is declared as type 'struct<aid:string,kvstriggerlambdaresult:string,sak:string,savecallrecording:string,sst:string,startstreamingaudiostatus:string,transcribecall:string,getlang:string,getaeroplanno:string,getemergency:string,getholiday:string,getlanguage:string,getlanguageselected:string,getpin:string,getpriority:string,language:string,userlanguage:string>', but partition 'partition_0=ctr/partition_1=2022/partition_2=04/partition_3=04/partition_4=12' declared column 'attributes' as type 'struct<getaeroplanno:string,getemergency:string,getholiday:string,getlanguage:string,getlanguageselected:string,getpin:string,getpriority:string>'.

In Redshift, we can use below query to get list of tables and it's size select table, size from svv_table_info where "database" = 'dev' and "schema" = 'public' Do we have anything similar in quicksight?

I'm trying to connect AWS OpenSearch to QuickSight and export data to SPICE, but I get ELASTICSEARCH_CURSOR_NOT_ENABLED exception. I was not able to find how to enable cursor for opensearch distro 1.1 - region:eu-west-1 - timestamp:1649003264494 - requestId:95b8a137-9839-453c-affc-f50c0e32ae4e - sourceErrorCode:ELASTICSEARCH_CURSOR_NOT_ENABLED - sourceErrorMessage:The domain monei-prod has not enabled cursor.

I would like to park my personal Quicksight account (enterprise billing) so that I am not billed while it is inactive. Is there a way to backup Quicksight dashboards/assets, import formulas, visualizations, other metadata, etc? Or is the only way to reduce the billing is to discard and lose all experiments?

When I try to populate a range of percentage values in my column, it seems to just aggregate all the percentages and provide (before selection) outputs like: 2,291.88 % or 2,700 % The values in my columns are already in percentage form. I would like to produce the exact percentage value on my KPI visualisation tile, if one day is selected on my calendar. If I select a few days, can I produce a more resonsable average percentage value for those days instead of values like: 2,291.88 % or 2,700 %

I have created a date range filter (in calendar format), based on Start and End dates. The intended output should be, as I click a range of dates from the filter, I would like to be able to break the range of days into disparate weeks. For example, if I chose Feb 4th to Mar 3rd, it should show me 4 weekly lines of data (4th to 10th, 11th to 16th, 17th to 23rd, 24th to 3rd). However, for now, when I select this range of dates, I get pre-populated outputs in my Pivot table. My output Pivot table uses a date column (set to Week setting). Does anyone know how this can be implemented ? Do I need to use some calculated fields intead ? For example dividing any number of dates selected on the calendar with 7 days ?

I am using logs as data source and want to visualise time series data in AWS QuickSight. I filter on specific identifiers. It is important to monitor the complete time series, including anomalies. The subtitles of the scatter plots say "**Showing top 50 in column_1 and top 14 in column_2**". How does QuickSight select the data shown in visualizations? And how can I avoid this automatic selection (as I do not want to lose any data points)? I want to monitor all raw data.

I have embedded dashboards in an application from quicksight. I want to restrict data access to some users where they can view data relevant to them only and not the complete dataset. Is there any way we can do this without using session capacity pricing?

I am trying to use a parameter to create a set of records that can be filtered. I've created a parameter audience with the options of retrieving all the audience or a subset of registers from the register column. The filter is created with the below calculations with the following ifelse but the visual is giving me a type error (CONTEXTUAL_INVALID_ARGUMENT_TYPE). Can someone advise on the best way to do so? ifelse(${audience}='all', 1=1,${audience}='registrants', register=1, 1=1)

Hello! I'm trying to migrate a QuickSight dashboard from one account to another, working out of [this article](https://aws.amazon.com/blogs/big-data/biops-amazon-quicksight-object-migration-and-version-control/). It gathers the details of each dataset, including the Physical Table Definition and Logical Table Definition. Once it has these, it modifies the dataset definition to point to the new data source, and then runs [create_data_set()](https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight.html#QuickSight.Client.create_data_set) to replicate the dataset in the new account. When I run create_data_set() it works for 70% of our datasets. But for a few, it returns this error: `An error occurred (AccessDeniedException) when calling the CreateDataSet operation: User: arn:aws:iam::12345678910:user/my_user is not authorized to access this resource` I can't find the reason why it fails for some datasets and works for others. I also can't figure out what resource I'm being denied access to - it's trying to create a dataset, so what resource is it being denied? For the record, my user has AdministratorAccess. I would greatly appreciate any information about what permissions are needed to run create_data_set(), and what resources are being accessed, or anything else that could help me figure out what is going on with this error. Thank you!

I'm looking for different methods for date selection, that should be user-friendly in quick sight. Can someone suggest? Thanks

Hi, I want to publish the dashboard created, with another logo instead of the quick sight logo. Can you suggest some methods to replace it?

I am trying to modify the column width of the pivot table. When I refresh the page, the changes I have made are not updated in the table. Is there any way to prevent the pivot table from resizing?

Hello, I have multiple different CSV files that I receive via email, on a day to day basis. I would like to build a pipeline to ensure that any datasets that I receive through emails, can be picked up by Quicksight automatically and all the updates are done without much intervention. As a result I thought of the following: 1) Update all the CSVs (from email) I get each day, into S3 Buckets. 2) Point the S3 buckets to AWS Athena. 3) Quicksight will use Athena to do automatic visual updates. For this to work, I will have to ensure that the data manipulation is done outside AWS, and then manually update CSVs inside S3 buckets on my own, each day. Another alternative idea is the following: 1) Place all data into S3 Buckets. 2) Use Glue data brew to manipulate data. 3) Store it back to S3 buckets. 4) Use Quicksight to visualise data (pointing it back to S3 buckets). Can someone please advise of a better method than this ? I am looking for more automation and easier methods of manipulating data for Quicksight to update each day. My data columns don't change, but new date fields and values are added each day.

Hi, I have a TimeStream table containing power consumed by IoT devices. I would like to create a calculated field in QuickSight which computes the sum of last power values reported by all devices?

I have a timestream table that has timestamps in GMT. I need to do two things with this time: 1. Shift it to my timezone. 2. Determine what shift the timestamp happened in. It looks like there is an Excel like ifelse() statement. I have 22 different shifts to examine for. Those cascading ifelse() will get quite complicated. Is there a better way of doing this?

I am working on the QuickSight embedded report url generation. I am trying to set the parameter default value programatically using below JAVA code.It is not working. ``` GetDashboardEmbedUrlRequest req = new GetDashboardEmbedUrlRequest() .withAwsAccountId(awsAccountId) .withDashboardId(reportInput.getDashboadId()) .withUserArn(userArn) .withIdentityType(EmbeddingIdentityType.QUICKSIGHT) .withSessionLifetimeInMinutes(sessionTimeout); req.putCustomQueryParameter("CampaignName", "ABC"); req.putCustomQueryParameter("reportDev", "Program"); // get the dashboard URL String embedUrl = quickSightClient.getDashboardEmbedUrl(req).getEmbedUrl(); LOGGER.info("URL:{}",embedUrl); ``` In the above code, "CampaingName" is multivalues parameter attached to the dropdown control. It's default value is set to "[All]" while building a report. Parameter "reportDev" is single value parameter with no default value and no control or any thing attached to it. Dummy parameter I introduced for testing. After running the code, when I copy the url printed in console by logger and run it in the browser, report opens properly but with "CampaignName" and "reportDev" both set as "ALL". Sample generated ulr is as below ``` https://xx-xxxx-x.quicksight.aws.amazon.com/embed/xxxxxxxxxxxxxxxxx/dashboards/xxxxxxxxxxxxxxxxxxx?code=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&identityprovider=quicksight&isauthcode=true ``` Well if I get the dashboard url and pass the parameter in the url to, it worked properly. "CampaignName" is set to "ABC" and "reportDev" set to "Program". According the data in the report also got filtered. Url working corrctly as below. ``` https://xx-xxxx-1.quicksight.aws.amazon.com/embed/xxxxxxxxxxxx/dashboards/xxxxxxxxxxxxxxx#p.reportEnv=Program&p.CampaignName=ABC ``` Can anybody please tell me what is missing in my code. I tried below variation as well but no luck. ``` req.putCustomQueryParameter("p.CampaignName", "ABC"); req.putCustomQueryParameter("p.reportDev", "Program"); ```

I'm trying to figure out how to find the dashboard and analysis IDs for QuickSight dashboards and analyses that I am working on. My ultimate goal is to port them over to another account. I found [this article](https://docs.aws.amazon.com/quicksight/latest/APIReference/API_GetDashboardEmbedUrl.html#API_GetDashboardEmbedUrl_RequestSyntax) which references a dashboard ID, but I can't figure out how to actually find it. I see some stuff on StackOverflow that involves creating a Cognito instance and I'm wondering if that's really the only way? This seems like something that should be pretty easily accessible without needing to write a script or creating new resources. Julian

I created a heat map visual in a QuickSight analysis. It used to work, and now it is giving this error: > The dataset changed too much for QuickSight to automatically update your analysis. You can edit the fields or filters in the current dataset, or replace it with a different dataset. I can't find anything about this error on google or in re:Post, and would appreciate some help in figuring out what causes this. There is a link for further information but it just takes me to the QuickSight front page. Here are other details that may be pertinent: 1. The row contains a single string identifier, the column is a datetime column, and the measure is an integer 2. The error says the dataset changed, and I believe this to be the case, but I'm not 100% certain how it changed (it was modified by someone else and I don't recall how it differs from how it originally was). 3. The dataset currently joins a custom SQL query dataset with a dataset that pulls an entire table from our DB. The two datasets are joined on a string column that's not unique in either dataset. 4. We pull all our data from a Redshift DB 5. When I remove any of the new columns that were added and leave just the barebones ones I need here, I still see the error 6. If I delete the analysis and try to create a new one with this dataset, it will show me the error the moment I add any column into any field well. If I delete the column from the field well, it still shows the error even though there are no longer any values in the empty field wells. it seems like something just... broke the dataset. Any help with this appreciated, thank you for taking the time to read this.

When I send an email report to myself, the email has no attachments but when I forward the report to leadership then I end up with an attachment for each section of the dashboard. How do I stop this from happening.

I have a table in my QuickSight analysis. The table contains one column and multiple rows with textual data. I have set the table header width to match the analysis editor width, which unfortunately is dependent on the screen width. Now I want like to make a pdf-report out of my analysis. The problem is that currently the table in the pdf-report is only 2/3 of the pdf width. I would like that the table width would match exactly the pdf width. Is there any easy way on how I can get the table width to match the pdf width? E.g. is there a way to define the graph heights and widths with a pixel value?

I have created a table with one column and multiple rows into my analysis. I want to create a pdf-report from my analysis that contains the table and some other visualisations. The problem that I am facing is that when I create the pdf-report from the analysis, the pdf does not show the whole table, but instead cuts only part of it vertically, showing only some of the rows in the table. How can I make the whole table show on my pdf-report?

I have a table in AWS QuickSight that contains one column with multiple cells containing texts of different lengths. I would like to keep the width of the table fixed with varied cell height depending of the text length. I have managed now to make the table to be of fixed width and set the "Wrap text"-option on from Format visual > Cells > Wrap Text. Nevertheless the only option for changing the cell height that I have found has been Format visual > Cells > Row height, but this will change the row height for all of the cells to be the same, which is not what I want. Any ideas on how can I define the height to be dependent on the content length?

AWSTemplateFormatVersion: '2010-09-09' Description: 'Creating QuickSight data source' Resources: QuickSightDataSource: Type: AWS::QuickSight::DataSource Properties: AwsAccountId: !Ref AWS::AccountId Name: Testing Data Source Type: ATHENA DataSourceId: testing-data-source DataSourceParameters: AthenaParameters: Workgroup: primary Permissions: - Actions: - quicksight:DescribeDataSource - quicksight:DescribeDataSourcePermissions - quicksight:PassDataSource Principal: !Sub - 'arn:aws:quicksight:us-east-1:${Account}:user/default/my-user-name' - Account: !Ref AWS::AccountId QSDataSet: DependsOn: QuickSightDataSource Type: AWS::QuickSight::DataSet Properties: AwsAccountId: !Ref 'AWS::AccountId' DataSetId: 'QSDataSet-test' ImportMode: SPICE Name: Dataset-test Permissions: - Actions: - 'quicksight:CreateDataSet' - 'quicksight:DeleteDataSet' - 'quicksight:DescribeDataSet' - 'quicksight:DescribeDataSetPermissions' - 'quicksight:PassDataSet' - 'quicksight:UpdateDataSet' - 'quicksight:UpdateDataSetPermissions' Principal: !Sub - 'arn:aws:quicksight:us-east-1:${AWS::AccountId}:user/default/my-user-name' - Account: !Ref 'AWS::AccountId' PhysicalTableMap: downtime_data_json: DataSourceArn: !GetAtt QuickSightDataSource.Arn InputColumns: - Name: downtime Type: INTEGER Schema: XXX??? I have data source & data tables in Athena and want to refer that in above template. I am not finding DatasourceArn, the above template throwing error as Model validation failed (#: extraneous key [DataSourceArn] is not permitted)". can anyone please help me out to hash out this.

I am trying to built out an Amazon Quicksight data set and keep getting an error when bringing in a new table/dataset (I currently have 11 tables/datasets in my model). The error information that I am receiving is not at all informative. I am wondering if anyone has experienced something like this or if there is a known limit on the number of tables/datasets that can be brought into a single data set?

I have added a table into my QuickSight analysis that contains on each rows textual feedback on our service. The problem that I am facing is that some of the textual feedbacks are really long making the table width huge, as it tries to keep the texts in a single line. QuickSight handles viewing the whole line by adding a horizontal scroll bar to the table. For my usage this is nevertheless suboptimal, as I would like to create a pdf-report out of my analysis and the pdf creation tool will cut the texts on the pdf page width and leave textual content out of the table. What I would like the system to do is that if the text in an individual cell is really long, that it would increase the cell height and present the text in multiple lines. I have tried to do this by increasing shell height from Format visual > Cells > Row Height and checking the Wrap text checkbox from Format visual > Cells > Wrap text. Nevertheless, this only makes the cell height larger and does not limit the table width, so the texts stay in one line and does not wrap it.

I have several datasets uploaded from xlsx files that have matching column names. Is it somehow possible to concatenate/unify these datasets into one? I tried to do this in Datasets > Edit Dataset > Add data, but there the only option for merging several datasets together was a join operation. Example: if I have a dataset with M -rows and N-columns and another one with M2 Rows and N columns, I would like that the final dataset after concatenation would be M + M2 rows and N columns

I am trying to upload an xlsx-file into AWS QuickSight, but I am encountering the following message: > Failed >Excel file: > file_name.xlsx >Failed to scan your file QuickSight does not provide any additional information on the possible reasons why the scanning of the file has failed. Are there any guidelines on how to find the reason that might be causing the failure?

Hi everyone. I have a question.. I'm looking for campaing name of pinpoint to include in my quicksight dashboard.. unfortunally I only have pinpoint metrics table generated in S3 and only campaing id (not name)... where I can find or get pinpoint campaign name ? is there son configuration or event..or table?

I have a requirement to export more than 1 million rows from a table visualization in QuickSight to a csv file or multiple csv files. How does QuickSight deal with data exceeding 1 million rows? Does it export it to multiple csv files? If not, what can be a good alternative to export all data from QuickSight to csv?

Documentation seems to state that QS can export data up to 1,000,000 rows. When attempting to export an analysis with 650,000 rows - the export shows as being "Limited to 100,000 rows" when exporting to Excel. The same export to a CSV file works, with the maximum row count of 1,000,000 applied. Is the Excel export actually limited to 100,000 - or is that limit being applied somewhere else? Many thanks!

Is there a quicksight api (REST or any other) available to refresh a dataset? I looked at the API reference guide and did not find on to refresh a dataset. There are API's available to create/update/delete datasets, but none to refresh it: https://docs.aws.amazon.com/quicksight/latest/APIReference/qs-data.html#qs-datasets Any help would be appreciated.

I am using Embedded Quick Sight session for registered user work flow. I enabled Q search bar and shared the topic to user with permission co-owner. but the Q Topics option in the left side is not visible.

Hi, I have created a calculated field (a percentage) and have formatted it as such in Quicksight. However, when I add this to a donut chart and choose 'Add Metric' it just shows as the value 0.095 for example and not 9.5% which is incredibly frustrating . Is there a way to format this as its % value and not the numerical value. Please note i am aware of "value and percent" but that percent is of the total, not the calculation.

I have a lot of customers who are using Quicksight for sales analytics. The problem is that most of them don't use a Jan - Dec Fiscal year. The "Relative Date Picker" is extremely helpful to filter data quickly, but can't be used in most cases because it is only based on a typical Jan - Dec calendar year. Is there anyway to change that (or can someone point me to where we can make suggested improvements to Quicksight?).

Hello, I can only select one record in the table and that selection be the filter for other visualizations on the page. How to add filters for other visualizations when I select more than one record in the table? Is it possible? Thanks.

Hello, When I tried to exclude elements from the visual, the Filter pane gets popped up. Is it possible to prevent this pop-up? Thanks.

In using the 'Waterfall' style graph in Quicksight, the "total" that is calculated is always found at the right-hand side (RHS) of the graph. This is true regardless of what sorting direction I use. In some situations, I want the "total" to be the first thing that readers see, so on the left-hand-side (LHS) of the graph. Does anyone know how to do this? This question is pretty basic, but it's either (i) impossible/not implemented yet or (ii) extremely well hidden. I've been searching online and reviewing formatting options within Quicksight for over an hour and can't find the functionality. Any help, or a definitive answer, would be greatly appreciated. Thanks!

In CloudWatch dashboard, is it possible to use math expressions (e.g. based on EstimatedCharges or some other metric) to create a metric that shows a budget, with month-to-month cloud spending gradually deducted from that budget? Example: Suppose there is a starting budget of $1000. The cloud spend is $200 in the first month, and $100 in the second. Hence, the metric needs to have an initial value of $1000, which decreases to $800 at the end of the first month, and $700 at the end of the second month. Can I use CloudWatch Dashboards with math expressions for this, or would other services be needed? e.g. QuickSight, Lambda?

Hello, I inherited a QuickSight Dashboard, Analysis and Dataset from a colleague who is no longer with the organization. The dataset is based on a **custom SQL** pointing to a PostgreSQL database. I was granted ownership of the dataset. However, I am unable to refresh it because I receive the following error: **"You can't execute the custom SQL query because you don't have sufficient permissions to connect to the underlying data source."** I am perplexed, I do have access to the data source and it is a shared data source. What do I need to do to get the dataset to refresh? Thank you.

Is it possible? Because in this file it says that the only valid file formats are csv and json. https://docs.aws.amazon.com/quicksight/latest/user/supported-manifest-file-format.html But when i upload the file directly .xlsx is allowed. Please help. Thank you

Hello, I am trying to analysis a few datasets (which are all bigger than 1GB), and they are mostly either CSV or Excel datasets. The goal is to be able to build dashboards with different datasets. I found that upon trying to ingest them into Quicksight, I got this error: > quicksight File size cannot be greater than 1 GB I would appreciate some help from the experts on methods to resolve this. I have read that some methods are to use Athena or S3 as a solution, before being able to ingest the data into Quicksight to build dashboards - but I am not sure which is the best way. Could someone please help with a tutorial to get this resolved ? Thank you,

I have a Quicksight dataset with around 30M rows. I'm trying to visualize a TABLE from this data (filtering it to only show about 100 records) but it is **SUPER **slow to load (around 20 - 30 seconds). I've tried a number of different techniques to see if it is my formula fields, but other visuals using the same formulas (charts, graphs, insights) all load much quickly then the table visual. So, I think it is the visual rather than the calculation that is causing the slow down. Does anyone have a workaround for this? Would be great to have pagination as a future enhancement to handle this.

I wish to drive Quicksight by API, including the QSearchBar is this possible? The documentation says that QSearchBar is a valid option in the api on method call generate_embed_url_for_registered_user. However for me it throws the exception: ParamValidationError: Parameter validation failed: Unknown parameter in ExperienceConfiguration: "QSearchBar", must be one of: Dashboard, QuickSightConsole. Any Suggestions? Thanks.

Hi there, we have a timestream database in eu-west-1 region. I am trying to add this database to QuickSight to visualize it. All my attempts end up with "No tables found" during data source creation. Quicksight does not see my Timestream tables. Are there any permissions I must set to allow Quicksight listing my timestream tables? Can I find it anywhere in the documentation? All the tutorials "just work" or this part is skipped. Thanks for any advice. David

I am creating a dataset in AWS Quicksight using custom SQL which I prepare/test in Athena. However, unless I define each join/table "databasename".table, the QS custom SQL fails. I have tried the below but it has failed. Is it possible to instruct the query to fun against a specific DB at the beginning of the query? ``` USING AwsDataCatalog."databasename" ```

I am able to successfully embed Quicksight dashboards using the multitenancy (namespaces-based) approach described in Quicksight's documentation. However, when I try to embed a Q Search Bar, the request completes successfully, but it generates a blank iFrame. Are Q Search Bars only allowed to be embedded for users in the default namespace? If not, how can I go about granting access to Q Topics to users in different namespaces and successfully embedding the Q Search Bar? Here are some additional details: I've followed the Amazon Quicksight documentation for embedding dashboards for registered users as well as embedding the Q search bar for registered users. I've created a workflow that creates namespaces and uses row level security to restrict access based on namespaces / groups. While the dashboard embedding works fine for users created in their respective namespaces, the Q Search Bar embedding does not. This applies even if I create a Q Topic from the same dashboard that I can embed successfully for the namespace user. In both cases, the result is simply a blank iframe where the Q Search Bar should appear. The actual call to GenerateEmbedUrlForRegisteredUser does not throw an error when attempting to embed the Q Search Bar for a user from the namespace - the returned link just generates a blank iFrame. However, if I use same operation ( GenerateEmbedUrlForRegisteredUser) using the OWNER account in the default namespace, the embedded Q Search Bar works fine. This appears to suggest that there is some sort of permissions issue at play. I cannot find any documentation that covers how to use the API to grant access to a Q Topic to a user in a specific namespace. I've tried removing RLS as well, but the iFrame is still empty. Any help would be greatly appreciated.

Edited Question: I have animal movement data and I need to show how the animals move around a habitat. Using lat/long data is possible, the locations are sometimes a few feet from each other..google maps or other online map services will not be able to provide any useful information about this space. I have considered putting the data over a photo of the habitat... Long story short, I have location data for a that I want to show how animals are moving in a relatively small space (a space that cannot be represented in a generic map).

In SPICE -> I have one simple query ag select * from <db>.public.<tableName> and when I try to full refresh the spice it give me error as sourceErrorCode: 500310 sourceErrorMessage: [Amazon](500310) Invalid operation: permission denied for relation <tableName>; sourceErrorState: 42501 sourceException: java.sql.SQLException sourceType: REDSHIFT FYI: I can perform the same query on query editor, it works fine. I also granted the full permission to my user using GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public to <userName>; any help?