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.
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 ☹️