Sharepoint list format change

[Dunner2020]

Hi there,

I am reading a list from sharepoint. When I read the list, some of the fields did not come up with the same format as it was on sharepoint. For example, I attached snapshot of the column from sharepoint

However, when I imported into Power Bi, it looks as follow:

Does anyone know why is it happening and how to fix it?

[v-eqin-msft]

Hi @Dunner2020 ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you‌‌😀

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Dunner2020 ,

You may try to use

Html.Table([This column],{{"PlainText",":root"}} )

to convert data from HTML to Plain Text.

Refer to:

https://www.youtube.com/watch?v=4UDynnPQpG4

https://social.technet.microsoft.com/Forums/lync/en-US/b080d122-14f0-43bc-8a86-f50cdf1c32d8/removing...

https://stackoverflow.com/questions/63135829/convert-html-column-to-plain-text-in-power-bi

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

Hi @Dunner2020 ,

This is not a display format issue in Power BI.

If you increase the width of the column it should display the information in a single line.

Thanks,

Pragati