Forum Discussion
Web.BrowserContents - Expression.Error: We cannot convert the value type "Table" to type "Text"
Hi woolf - The error "Expression.Error: We cannot convert the value type 'Table' to type 'Text'" usually occurs in Power Query when you try to use a table as if it were a text value.
try the below example:
let
Quelle = Web.BrowserContents("https://example.com"),
ExtractedTable = Html.Table(Quelle, {
{"Bez.", "DIV.ov-carousel > DIV.ov-carousel__wrapper > DIV.ov-carousel__inner > TABLE > * > TR > :nth-child(1)"},
{"2026e", "DIV.ov-carousel > DIV.ov-carousel__wrapper > DIV.ov-carousel__inner > TABLE > * > TR > :nth-child(2)"}
}, [RowSelector="DIV.ov-carousel > DIV.ov-carousel__wrapper > DIV.ov-carousel__inner > TABLE > * > TR"]),
ConvertedToText = Table.TransformColumnTypes(ExtractedTable,{{"Bez.", type text}, {"2026e", type text}})
in
ConvertedToText
Replace https://example.com with your actual URL and adjust the HTML selectors as necessary. This should help resolve issues related to data type conversion and HTML extraction complexities.
- woolf1 year agoFrequent Visitor
Unfortunately it didn't solve my problem to go automaticlly through all the links in the table and provide me all datas for the links ☹️