Forum Discussion

stiggrr87's avatar
stiggrr87
Helper I
5 years ago
Solved

Dataflow with web error

Can I get this code working in dataflow???

 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("PY1NDoIwEIWv0syaUNi4YGeiOzXs28Y0MMYaoNAOJIZwG2/ixaTyM4uZ5HvvzRMCnkStzzjXTVljGXvSFCNy3Ro+pByJB8LzY5IcQEUCRsYkdD26t4SMCTbPyP4jobAlBirh9v0Y0i8tIdpEjxUWZGwTHGsk8IepCN0SM4T1HgnioKse/d604VOa3s/X/CJhY2o507pUFGwOfWsbj3vj3GZdrWlpK/wQHkwTKPUD", BinaryEncoding.Base64), Compression.Deflate))),
Link = Source{0}[Column1],
Query_text_raw = Table.Skip(Source,1),
#"Replaced Value" = Table.ReplaceValue(Query_text_raw," ","",Replacer.ReplaceText,{"Column1"}),
Query = Csv.Document(Web.Contents(Link,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(#"Replaced Value"{0}[Column1])]))
in
Query

 

I get error that "One or more entities references a dynamic data source... "

2 Replies