# Urgent: No data in analyses/dashboard, but dataset has 'Data' **URL:** \ **Category:** Q&A\ **Tags:** data-source, Business-Intelligence-Engineer, quick-sight\ **Created:** [January 16, 2024, 10:28pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753 "2024-01-16T22:28:23Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![irinaaaaa](https://avatars.discourse-cdn.com/v4/letter/i/ad7895/32.png) [@irinaaaaa](https://community.amazonquick.com/u/irinaaaaa)\ **Post date:** [January 16, 2024, 10:28pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/1 "2024-01-16T22:28:23Z")
Hello, I am now building an analyses, and for one of the metrics, the data shows up perfectly on the dataset page. However, when I was building the analyses, there was no data for that metric!!! Does anyone know what is going on here?? Why is this happening? For additional procedures, I’ve tried: - I published the analyses to the dashboard, and still no data for that specific metric. - I refreshed the dataset multiple times, and still no data for that specific metric. - I’ve created a blank new sheet and visual and added only that metric, and still no data. Everything else works perfectly!! Please assist. Very urgent. Thank you. ---
**Author:** ![Sophia](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@Sophia](https://community.amazonquick.com/u/Sophia)\ **Post date:** [January 17, 2024, 7:16am UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/2 "2024-01-17T07:16:44Z")
Hello, if you’re not using any filter but the data still can’t see, I would recommend filing a case with AWS Support towards Quicksight team. Please use “Chat” method and give support engineer a link to join your screen sharing session. That’s the fastest way to resolve it. Hope it helps. ---
**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\ **Post date:** [January 17, 2024, 11:40am UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/3 "2024-01-17T11:40:50Z")
Hi @irinaaaaa any RLS implemented, is the metric a calculated one, did you republished the dataset? BR ---
**Author:** ![irinaaaaa](https://avatars.discourse-cdn.com/v4/letter/i/ad7895/32.png) [@irinaaaaa](https://community.amazonquick.com/u/irinaaaaa)\ **Post date:** [January 17, 2024, 5:44pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/4 "2024-01-17T17:44:01Z")
Hello @ErikG, - What is RLS? - the metric is not a calculated field, it is a metric that directly comes from the database. - The dataset was refreshed multiple times, if that is what you meant by re-publish ---
**Author:** ![irinaaaaa](https://avatars.discourse-cdn.com/v4/letter/i/ad7895/32.png) [@irinaaaaa](https://community.amazonquick.com/u/irinaaaaa)\ **Post date:** [January 17, 2024, 5:44pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/5 "2024-01-17T17:44:53Z")
Hello @Sophia, Any recommendations regarding what I should do? What might be the cause it? Anything I can try to solve this on my own? ---
**Author:** ![irinaaaaa](https://avatars.discourse-cdn.com/v4/letter/i/ad7895/32.png) [@irinaaaaa](https://community.amazonquick.com/u/irinaaaaa)\ **Post date:** [January 17, 2024, 6:16pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/6 "2024-01-17T18:16:51Z")
In general, is it possible to do a direct query refresh to a dataset with only SPICE refresh available now? I suspect a direct query refresh might solve this problem. Overview of my dataset: - Two big datasets left joined together from different databases. - The Direct Query button (aka. little box) is not showing up for this dataset. ---
**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\ **Post date:** [January 17, 2024, 6:41pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/7 "2024-01-17T18:41:15Z")
Hi @irinaaaaa - Row Level Security - no I meant edit → save & publish - in general you can switch from SPICE to direct query. If both datasets are using the same datasource. BR ---
**Author:** ![Sophia](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@Sophia](https://community.amazonquick.com/u/Sophia)\ **Post date:** [January 18, 2024, 2:25am UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/8 "2024-01-18T02:25:24Z")
Hello, usually data shown in dataset but not in analysis due to the following reasons: 1. Joint dataset never republished to be used by analysis 2. Row level security (RLS) or Column Level Security (CLS) policy restrict it from viewing by the user 3. Joint result not happened properly in SPICE Accordingly, you can check: 1. If you’ve republished the joint dataset 2. If you have any RLS or CLS restrict the metric from viewing for this author or user 3. Use direct query. I suggest you check if this metric will show up without JOIN operation (load that dataset individually and plot a chart in analysis). If that’s okay, then it’s the JOIN issue. Hope it helps. ---
**Author:** ![irinaaaaa](https://avatars.discourse-cdn.com/v4/letter/i/ad7895/32.png) [@irinaaaaa](https://community.amazonquick.com/u/irinaaaaa)\ **Post date:** [January 18, 2024, 5:22am UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/9 "2024-01-18T05:22:04Z")
Thanks @Sophia and @ErikG, 1. The joint dataset was edited, saved, and published for multiple attempts on multiple days. And it doesn’t help. 2. No RLS and CLS is applied to the dataset 3. I’ll check if the metric will appear from the individual dataset. ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [February 19, 2024, 4:55pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/10 "2024-02-19T16:55:02Z")
Hello @irinaaaaa , @Sophia , and @ErikG ! @irinaaaaa were you able to try @Sophia 's last suggestion of importing both datasets individually without the join in direct query to see if you can load the metric or were you able to find another solution? if you were able to find a solution could you share it with the community? ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [February 21, 2024, 3:38pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/11 "2024-02-21T15:38:57Z")
Hello @irinaaaaa , @Sophia , and @ErikG ! @irinaaaaa were you able to attempt @Sophia’s last suggestion and try importing the datasets individually or were you able to resolve this problem on your own? It has been some time since we have heard from but would still like to help you find a solution. If we do not hear from you in the next 3 business days this topic will be archived. ---
**Author:** ![irinaaaaa](https://avatars.discourse-cdn.com/v4/letter/i/ad7895/32.png) [@irinaaaaa](https://community.amazonquick.com/u/irinaaaaa)\ **Post date:** [March 19, 2024, 3:13pm UTC](https://community.amazonquick.com/t/urgent-no-data-in-analyses-dashboard-but-dataset-has-data/23753/12 "2024-03-19T15:13:39Z")
This is now resolved through the chat with the QS team. For anyone that has a similar issue, it’s because of inaccurate data type from the data source. e.g. my original data source has `600,000` with String data type, thus, when converting the data type at QS dataset page, I’ve converted it directly to `float`. However, because of the `,` in the string data type, all values with `,` in are unable to be converted but have a NULL value instead. As a result, the solution is to remove the `,` in the value using the `REPLACE()` function and then convert the data type to FLOAT.