I have 2 datasets which one of them is included and joined on the other.
if I apply RLS on it, the join doesn’t work and i get an error message:
" joining tables from different sources require SPICE, which this dataset isn’t permitted to use. To continue, you’ll need to remove the join".
Any advice how can I keep the join and the RLS together?
Yes, I meant that you will need to have the RLS dataset be SPICE.
The change in the dataset should only be renaming column names. For that I would make a separate dataset, do the join in SQL and then replace the dataset in the analysis. From there you can map column names to new column names.
I had the exact same issue a few weeks ago and was able to resolve it. The dataset was originally imported without SPICE. When I changed it to run with SPICE later it didn’t work and I got the same error you did. I’m not sure if it’s a bug in QuickSight, but I completely removed the dataset and re-added it as SPICE from the start. After that, I was able to apply RLS.