Unable to Save or Publish Datasets

Question & Answer
, , , ,
1

Hello, I’ve imported two datasets from SQL Server into SPICE. I’ve successfully added join conditions between them and can see the expected results in the preview section, which suggests the join is functioning correctly. However, the Save & Publish or Publish & Visualize options are greyed out/not working except the cancel button and I’m unable to proceed. Could you help me understand why this might be happening and how I can resolve it? Thanks

please see the below images

image
image1895×342 32.2 KB

2

Hi @pavan_Ch

Welcome to the QuickSight community!

Check the SPICE size limit. When both tables are in SPICE, the combined size of secondary tables in a join must be ≤ 20 GB. If it exceeds that, QuickSight will block publishing. Refer to this documentation.

Please check the permissions. If you lack publish rights for the dataset or the underlying data source, the Save & Publish option will remain disabled.

1 Like
3

Hi @Xclipse,

Thanks for the information, the combined size is less than 20 GB, but it still won’t allow me to save, to make sure I have imported small sized datasets into the spice, applied joins but still it won’t let me save it.

Steps I have Taken to Combine and Join Datasets that are in SPICE:

  1. Created new datasets from both the legacy and new systems. (lets say legacy_dataset and new_dataset).
  2. Imported both datasets into SPICE and successfully confirmed by completed refresh showing record count, dataset size, and duration.
  3. Opened the legacy_dataset, clicked Edit Dataset, then selected Add Data.
  4. Chose the new_dataset and applied join conditions.
  5. Verified that both datasets were in SPICE and that the data preview displayed correctly, confirming the join was successful.

Is this the correct way to join datasets that are already in spice and that joining is allowed ?

Thanks for your time.

4

Hi @pavan_Ch

Could you please confirm whether you tried the join after creating a legacy_dataset and new_dataset, both imported to SPICE, then opening legacy_dataset → Edit Dataset → Add Data → selecting new_dataset?

Try switching the import mode to Direct Query for legacy_dataset and then join it with new_dataset.

Please test this, and it would be helpful if you could share a screenshot or any error message.

5

Hi @Xclipse,

Looks like the issue got resolved by itself, probably a glitch.

But to your question, yes, I have tried the same way as you mentioned, first importing both the data sets into spice, edit legacy dataset and then add new data set. I have also tried the other way by switching the mode to Direct.

Thanks so much for your help on this issue.