Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

New bug encountered with Html.Table function (Power Query, M)

Submitted by Anonymous on ‎04-06-2023 10:42 AM

A new bug has been encountered: Power Query (M) function "Html.Table" no longer works in PBI Services. I use this function to strip HTML code/tags from strings in multiple disparate datasets (all are SharePoint lists).

Overnight (2023-04-06) this function has begun throwing errors during PBI Services data refreshes. Refreshing locally works fine, no issues either during local refresh or when inspecting each step in PQ.


Anybody else encountering this, or could help test it? The setup is easy:

  1. Create a rich text format text column in a SP list.
  2. Ingest the list in PQ
  3. Create a custom column using this function: Html.Table([COLUMN NAME], {{"ExtractedText",":root"}})
  4. Publish report and wait for the refresh to fail/succeed.

I've found no other way to strip HTML from content, if you know of one please share!

Status: Investigating

Hi @Anonymous ,

I tested based on your steps, get a list of tables in the new custom column.

vyanjiangmsft_1-1680857371802.png

If I don't expand the tables, after publish to Service, the column still show "Table" as text.

vyanjiangmsft_2-1680857425597.png

If I expand the tables, it shows correctly in Service. Anything different with you?

 

Best regards,

Community Support Team_yanjiang

 

 

See more ideas labeled with:
3 Comments (3 New)
Comments
v-yanjiang-msft
Community Support
Community Support
‎04-07-2023 01:52 AM
Status changed to: Investigating

Hi @Anonymous ,

I tested based on your steps, get a list of tables in the new custom column.

vyanjiangmsft_1-1680857371802.png

If I don't expand the tables, after publish to Service, the column still show "Table" as text.

vyanjiangmsft_2-1680857425597.png

If I expand the tables, it shows correctly in Service. Anything different with you?

 

Best regards,

Community Support Team_yanjiang

 

 

Anonymous
Not applicable
‎04-11-2023 07:58 AM

Thank you for your quick reply, @v-yanjiang-msft !

If you expand the column to show its values (it should be the text without HTML elements) does your refresh still work?

I tried on a new workbook and new dataset and am still getting the same error:

Data source error:Expression.Error: We cannot convert the value <ccon>null to type Text.. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: [TABLE NAME].
Cluster URI:WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID:556620e4-3e84-e531-8670-4135a48d1a30
Request ID:19eff0d5-c057-2d99-e4cb-565f2075ba6b
Time:2023-04-11 14:32:57Z
Anonymous
Not applicable
‎04-19-2023 08:07 AM

I've finally had some more time to troubleshoot this issue: seems like if I convert all nulls to blank in a prior step then the function works as intended.

Idea Statuses