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
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
