Dataflow with web error

[stiggrr87]

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... "

[stiggrr87]

Hi!
I managed to figure out that I need to use parameters in Web.Contents() instead hard coded input. Dataflow is working now and refresh can be scheduled 😉
Thanks for the good hints!

[v-easonf-msft · Accepted solution]

Hi , @stiggrr87 

You can check  these related thread:

Bug-Can-t-save-dataflow-Same-queries-work-in-Power-BI-Desktop 

Dataflow-Error-on-save-dynamic-data-source 

Issues-with-using-a-parameter-in-web-content-url-in-dataflow 

In addition, you can open a support ticket to let engineers look into the issue on your side.

Best Regards,
Community Support Team _ Eason