text error

Hi Experts

I really need some help here. This is driving me insane.

I have a simple Sharepoint form with data:

The HTML source is:

And when I import with OData.feed to Power BI, I get this:

What Am I missing to either get the <p> and/or <br> tag interpretated OR if that is not possible, is there a way to get  the HTML source insted of the text using OData??

THANKS!

Best regards

Jesper Storm

Hi jesperstorm,

Try Web.Contents instead of OData.feed and check if it can work.

https://docs.microsoft.com/en-us/powerquery-m/web-contents.

Regards,

Jimmy Tao