Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Custom SQL option when we are using VERTICA direct query

    Vote (22) Share
    's profile image

    on 07 Feb 2019 03:29:47

    We are able to access the Vertica direct connectivity mode, but not allowing us to write the required SQL code. Please help with this option asap,

    Comments (2)
    's profile image Profile Picture

    Gonzalo Moran on 07 May 2021 07:09:05

    RE: Custom SQL option when we are using VERTICA direct query

    I have tried power query M nativeQuery but it doesnt work

    let
    Source = Vertica.Database(DWH_HOST, DWH_INSTANCE, null),
    DWH_Schema = Source{[Name="DWH",Kind="Schema"]}[Data],
    D_CUSTOMER_Table = DWH_Schema{[Name="D_CUSTOMER",Kind="Table"]}[Data],
    Custom1 = Value.NativeQuery(D_CUSTOMER_Table,"SELECT * from DWH.D_CUSTOMER")
    in
    Custom1

    And Microsoft doesnt have documentation regarding which sentences are supported per connector

    's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:40:24

    RE: Custom SQL option when we are using VERTICA direct query

    Vertica direct query not supporting users through LDAP, ODBC supporting but not allowing direct query.