Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

text error

Hi Experts

 

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

 

I have a simple Sharepoint form with data:

 

Capture.PNG

 

The HTML source is:

Capture.PNG

 

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

Capture.PNG

 

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

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

Hi jesperstorm,

 

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

Capture.PNG 

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

 

Regards,

Jimmy Tao

Anonymous
Not applicable

Hi Experts

 

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

 

I have a simple Sharepoint form with data:

 

Capture.PNG

 

The HTML source is:

Capture.PNG

 

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

Capture.PNG

 

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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors