Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
chu_en
Frequent Visitor

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

1 ACCEPTED SOLUTION
v-zhenbw-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-zhenbw-msft
Community Support
Community Support

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.

Okay, thank you

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors