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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
nisha_deepak
Helper III
Helper III

special character showing issue while fetch from postgresql database to power bi desktop

i am  creating a report in desktop using data taken from postgresql database.I use postgres odbc driver .Capture.PNG

while fetching data using select query i try like this.

Capture1.PNG

After loading data from db to power bi desktop some of the data is not correctly showing like in database.Some data is showing like special characters.But the problem is some of the same value having issues ...some of the same data is not having any issue.

MY database column is like this.

1.PNG

But same thing is showing differntly in powerbi

2.PNG

here 2 value in column is entirely different compare with data from database .These type of lot of data having issue.

Plse give some suggestions.

 

 

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@nisha_deepak 

This " - “ might be unsupported characters in power bi if it is recorded using input method of other languages. Try replace " - “ with the same "-" enter by "English(United States)". Or just replace "-" to other characters e.g. ">" or "@".

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@nisha_deepak 

This " - “ might be unsupported characters in power bi if it is recorded using input method of other languages. Try replace " - “ with the same "-" enter by "English(United States)". Or just replace "-" to other characters e.g. ">" or "@".

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

V-pazhen-msft
Community Support
Community Support

@nisha_deepak 

What is the datatype of the columns in your DB, and what does it become when  loaded into power bi?

 

Paul

In Db and power bi column is text daattype

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.