Forum Discussion

chu_en's avatar
chu_en
Frequent Visitor
5 years ago
Solved

PostgreSQL TYPE LTREE

Dear PowerBI Community,

i'm connect to table from postgreSql which using ltree, and it got error,


Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] PostgreSQL: 42883: no binary output function available for type ltree. '.

 

please help me

Need Help
Tutorial Requests
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi chu_en ,

     

    Sorry for that Power BI cannot support Itree type.

    Maybe you can cast to text in the sql to get the value to return.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    5 years ago

    Hi chu_en ,

     

    Sorry for that Power BI cannot support Itree type.

    Maybe you can cast to text in the sql to get the value to return.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.