PowerBI Query文本截断求助:突破1024字符限制
PowerBI文本截断问题求助
我是PowerBI新手,正面临文本截断难题——抓取的文本最大仅能保留1024字符。以下是我的GetData函数代码:
let GetData=(URL) => let Source = Web.BrowserContents(URL), #"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".fld"}, {"Column2", ".fld + *"}, {"Column3", "DIV:nth-child(8) .title"}, {"Column4", "BR + BR + A"}, {"Column5", "TR:nth-child(3) A"}, {"Column6", ".less *"}, {"Column7", ".more P:nth-child(1)"}, {"Column8", "TR:nth-child(7) BR + *"}, {"Column9", "TR:nth-child(3) P"}, {"Column10", "TR:nth-child(4) P"}, {"Column11", "TR:nth-child(5) P"}, {"Column12", "TR:nth-child(6) P"}, {"Column13", ".seemore"}, {"Column14", ".horipane STRONG"}, {"Column15", "TR:nth-child(4) .refanch"}, {"Column16", "TR:nth-child(5) .refanch"}, {"Column17", "TR:nth-child(6) .refanch"}}, [RowSelector=".fld"]), #"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type text}, {"Column17", type text}}), #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Column1", "Column2"}) in #"Removed Other Columns" in GetData
我尝试了相关解决方案但不知如何落地,希望突破该字符限制,特请教:
- 函数输出每个URL对应40多行数据,我需解决第一行的截断问题,不确定是否对应代码中的Column1?
- 函数中所有列已设为text类型,若采用替换值为文本类型的方案,应在何处编写代码?
内容的提问来源于stack exchange,提问作者Mete
相关产品推荐
相关产品推荐

