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
ansa_naz
Continued Contributor
Continued Contributor

How to display carriage return/linefeed in the table visual?

I am using SQL Server for my datasource. I have created a table visual in Power BI desktop, which pulls in various columns from a SQL Server table, including text columns. These text columns can contain carriage return/linefeed when viewed from the application (Dynamics AX) that sits on SQL Server. However, when I view the same information in Power BI, the carriage return/linefeed is not present, and the whole text is showing in one line

 

EG I have the following data from a row in SQL:

 

This is some sample text

It contains carriage returns and linefeeds

 

However, when I view the above in Power BI Table visual, I got the following:

 

This is some sample textIt contains carriage returns and linefeeds

 

Any idea how I can display it in the Table visual but include the carriage/linefeed?

 

Many thanks

2 REPLIES 2
v-danhe-msft
Employee
Employee

Hi @ansa_naz,

Could you have used the word wrap function? Based on my test, it could work to wrap your text:

Before:

2.PNG

After:

1.PNG

I suggest you test again.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-danhe-msft I dont think you are understand the issue? The data is coming from SQL Server, it is not typed into Power BI. So not sure how I can add a word wrap function as the linefeed/carriage return is in a different position for every record. Any ideas?

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.