<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Can't compute a dataset in Data Movement &amp; Streaming</title>
    <link>https://community.qlik.com/t5/Data-Movement-Streaming/Can-t-compute-a-dataset/m-p/2500486#M2985</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;
&lt;P&gt;I created a connection to load in a sample dataset from Postgres however I can't compute the data quality score or preview the data.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MoeyE_2-1736388289125.png" style="width: 788px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/176280i8C750BC059D8992A/image-dimensions/788x164?v=v2" width="788" height="164" role="button" title="MoeyE_2-1736388289125.png" alt="MoeyE_2-1736388289125.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;When I press compute I get this message.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MoeyE_0-1736388067163.png" style="width: 808px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/176278i86D07515A0C1F550/image-dimensions/808x101?v=v2" width="808" height="101" role="button" title="MoeyE_0-1736388067163.png" alt="MoeyE_0-1736388067163.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;However, when I select the table earlier in the setup steps, I am able to view the actual data.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MoeyE_1-1736388243134.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/176279i5B177A04A130E60E/image-size/medium?v=v2&amp;amp;px=400" role="button" title="MoeyE_1-1736388243134.png" alt="MoeyE_1-1736388243134.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;I uploaded a CSV file and I was able to view the data and quality score fine. I have a Microsoft SQL Server database which had the exact same issue. Any pointers as to what the issue could be? It looks like it's capable of viewing the data fine in the early steps.&lt;/P&gt;
&lt;P&gt;edit: The data gateway is on version 1.6.9. The prerequisites have all been completed according to the documentation.&amp;nbsp;&lt;A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway-setting-up.htm" target="_blank" rel="noopener"&gt;https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway-setting-up.htm&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;Edit2: I switched the direct access gateway connection and paired it to an older Qlik Cloud tenant that doesn't have any Qlik Talend capabilities, and I am able to connect the same data set and run compute successfully. However, this tenant doesn't have the Talend options for Data Quality or a data preview column.&lt;/P&gt;
&lt;P&gt;Edit 3: I was able to get the data quality and data preview capabilities to work when using a Snowflake connection. Could this be a Postgres specific issue? I'd like to get this working with Postgres if possible. Thank you.&lt;/P&gt;
&lt;P&gt;Edit 4: I found this link to some documentation that claims "if the schema and quality of the dataset fails to be retrieved, check if the connection you have set up in the Qlik Analytics Services hub has the&lt;STRONG&gt; Role&lt;/STRONG&gt; field properly filled, or if the role itself grants the necessary permissions on the database table.". Yet, I am unable to find the setting that is mentioned as it is not present in my tenant.&lt;/P&gt;
&lt;P&gt;Regards,&lt;/P&gt;
&lt;P&gt;Mohammed&lt;/P&gt;</description>
    <pubDate>Wed, 19 Mar 2025 21:46:28 GMT</pubDate>
    <dc:creator>MoeE</dc:creator>
    <dc:date>2025-03-19T21:46:28Z</dc:date>
    <item>
      <title>Can't compute a dataset</title>
      <link>https://community.qlik.com/t5/Data-Movement-Streaming/Can-t-compute-a-dataset/m-p/2500486#M2985</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;
&lt;P&gt;I created a connection to load in a sample dataset from Postgres however I can't compute the data quality score or preview the data.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MoeyE_2-1736388289125.png" style="width: 788px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/176280i8C750BC059D8992A/image-dimensions/788x164?v=v2" width="788" height="164" role="button" title="MoeyE_2-1736388289125.png" alt="MoeyE_2-1736388289125.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;When I press compute I get this message.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MoeyE_0-1736388067163.png" style="width: 808px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/176278i86D07515A0C1F550/image-dimensions/808x101?v=v2" width="808" height="101" role="button" title="MoeyE_0-1736388067163.png" alt="MoeyE_0-1736388067163.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;However, when I select the table earlier in the setup steps, I am able to view the actual data.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MoeyE_1-1736388243134.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/176279i5B177A04A130E60E/image-size/medium?v=v2&amp;amp;px=400" role="button" title="MoeyE_1-1736388243134.png" alt="MoeyE_1-1736388243134.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;I uploaded a CSV file and I was able to view the data and quality score fine. I have a Microsoft SQL Server database which had the exact same issue. Any pointers as to what the issue could be? It looks like it's capable of viewing the data fine in the early steps.&lt;/P&gt;
&lt;P&gt;edit: The data gateway is on version 1.6.9. The prerequisites have all been completed according to the documentation.&amp;nbsp;&lt;A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway-setting-up.htm" target="_blank" rel="noopener"&gt;https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway-setting-up.htm&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;Edit2: I switched the direct access gateway connection and paired it to an older Qlik Cloud tenant that doesn't have any Qlik Talend capabilities, and I am able to connect the same data set and run compute successfully. However, this tenant doesn't have the Talend options for Data Quality or a data preview column.&lt;/P&gt;
&lt;P&gt;Edit 3: I was able to get the data quality and data preview capabilities to work when using a Snowflake connection. Could this be a Postgres specific issue? I'd like to get this working with Postgres if possible. Thank you.&lt;/P&gt;
&lt;P&gt;Edit 4: I found this link to some documentation that claims "if the schema and quality of the dataset fails to be retrieved, check if the connection you have set up in the Qlik Analytics Services hub has the&lt;STRONG&gt; Role&lt;/STRONG&gt; field properly filled, or if the role itself grants the necessary permissions on the database table.". Yet, I am unable to find the setting that is mentioned as it is not present in my tenant.&lt;/P&gt;
&lt;P&gt;Regards,&lt;/P&gt;
&lt;P&gt;Mohammed&lt;/P&gt;</description>
      <pubDate>Wed, 19 Mar 2025 21:46:28 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Data-Movement-Streaming/Can-t-compute-a-dataset/m-p/2500486#M2985</guid>
      <dc:creator>MoeE</dc:creator>
      <dc:date>2025-03-19T21:46:28Z</dc:date>
    </item>
  </channel>
</rss>

