Ignore the font formating showing in the data

[Sazzy]

I connect my power bi with the list sharedpoint online.

There are few columns in sharedpoint is set as multiple line of text format.

Howerver, when it connected with power BI, those column shown as this.

<div class="ExternalClass250267F632084D999BBE934B3794D111"><span id="ms-rterangepaste-start"></span><font face="Verdana">Suresh </font> <span id="ms-rterangecursor-start"></span><span id="ms-rterangecursor-end"></span><span id="ms-rterangepaste-end"></span></div>

What I want is just " Suresh". How can I solve this ?

[v-jiascu-msft]

Hi @Sazzy,

It seems you applied the wrong steps. Can you verify the steps below?

1. Is it the connector SharePoint Online List?

2. What's the URL like? It should be like below without any subfolder.

Can you share more details?

Best Regards,

Dale