So, within SharePoint, if I create a new form (xsn format), and submit that, it gets added as a new row in the SharePoint, with xml file.
On the page, there is an option to "Export to Excel", which generates a Web Query File. And if this file is opened with Excel, it provides the value of columns exactly same as it is in the SharePoint (via the forms).
However, if I export the data from SharePoint directly to PowerBI, then some of the columns have values as [Tables].
Sharing an example of one column:
Actual Value:
| Issue_Desc |
| Service not available |
Output in Power Query:
| Issue_Desc |
| Table |
Here's the details from the XML file:
<my:Issue_Desc><html xmlns="http://www.w3.org/1999/xhtml" xml:space="preserve"><p><span id="ms-rterangepaste-start"></span>Service not available<span id="ms-rterangepaste-end"></span><br /></p>
</html></my:Issue_Desc>
Please advise if there is a way to fix it.
Thanks
Helpful resources
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
