Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Hi @ansa_naz,
Could you have used the word wrap function? Based on my test, it could work to wrap your text:
Before:
After:
I suggest you test again.
Regards,
Daniel He
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?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!