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....
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.

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.

  • chu_en's avatar
    chu_en
    Frequent Visitor
    5 years ago

    Okay, thank you