6 Replies Latest reply: Sep 15, 2016 4:13 PM by Bruce Armstrong RSS

    Issue Connecting to Qlik Data Market with Qlik Sense 3.0 -remote server returned an error: (400) Bad Request.

    Robert Levin

      I get an error like below or similar whenever attempting to access Qlik Data Market Free content?

      note: that I do not see a DM connection in the data connections area of the UI.

      All help appreciated in diagnosing this issue.

      -Robert

       

      ERROR OUTPUT

      8:06:23 TT

      The remote server returned an error: (400) Bad Request.: SQL SELECT "_dim_8q8e", "_dim_8q8f", "_dim_8q8g", "Year", "MEASURE=1" FROM fact:516m WHERE '8q8e' = '4.7' AND '8q8f' = '1' AND '8q8g' = '2.4' AND MEASURE = '1' AND TIME = MOST RECENT

       

      Code Segment
      LIB CONNECT TO [DM];

      [World population by country]:
      LOAD

        [_dim_8q8e] AS [_dim_8q8e],

        [_dim_8q8f] AS [_dim_8q8f],

        [_dim_8q8g] AS [_dim_8q8g],

        [Year] AS [Year],

        [MEASURE=1] AS [Persons];

      SQL SELECT

          "_dim_8q8e",

          "_dim_8q8f",

          "_dim_8q8g",

          "Year",

          "MEASURE=1"

      FROM fact:516m

      WHERE '8q8e' = '4.7'

        AND '8q8f' = '1'

        AND '8q8g' = '2.4'

        AND MEASURE = '1'

        AND TIME = MOST RECENT;