Forum Discussion

Krishna_29's avatar
Krishna_29
New Member
7 months ago
Solved

Power bi to redshift table direct query connection

getting the above error when connected to redshift table in direct query and trying to group int columns with a string column

  • DanieleUgoCopp's avatar
    DanieleUgoCopp
    7 months ago

    Hello,
    I think it's because in DirectQuery Power BI has to translate the visual logic into SQL that Redshift can execute.

    If you do the grouping directly in Redshift, for example in a view or SQL query, it should work or switching to Import mode also should fix the issue.

    Best,
    Daniele

     

3 Replies

  • DanieleUgoCopp's avatar
    DanieleUgoCopp
    Icon for Super User rankSuper User
    7 months ago

    Hello,
    I think it's because in DirectQuery Power BI has to translate the visual logic into SQL that Redshift can execute.

    If you do the grouping directly in Redshift, for example in a view or SQL query, it should work or switching to Import mode also should fix the issue.

    Best,
    Daniele

     
  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    7 months ago

    Hi Krishna_29 

    We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

    • v-aatheeque's avatar
      v-aatheeque
      Icon for Community Support rankCommunity Support
      7 months ago

      Hi Krishna_29 

      Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.