PostgreSQL TYPE LTREE

[chu_en]

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

[v-zhenbw-msft · Accepted solution]

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.

[chu_en]

Okay, thank you