how do i get rid of weird xml script language when pulling data from sharepoint?

[dandywong]

Hi there,

I'm having trouble finding a way to get rid of this weird xml script language. The data is being pulled from a SharePoint List data feed. The cells in the SharePoint List are empty, but when it gets populated in BI, is shows this weird xml script. Any ideas on how to get rid of this?

[v-piga-msft]

Hi @dandywong,

Which  Sharepoint list do you want to get in Power BI, Sharepoint Online list or on-premise Sharepoint list?

Have you tried to get Sharepoint data in Power BI Service? Do you still have this problem?

Could you describe your scenario in more details, so that I can have a test and do a research.

Best Regards,

Cherry