Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I want to consume json from a web, i add a column to this table and place a query to get json content from the web,
I got this error message:
Formula.Firewall: Query 'the_query' (step 'Added Custom') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
It makes error:
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Json.Document(Web.Contents("theURL")))
I am very sure i dont use reference from any other query or steps, it just this one line that makes error
What i am missing,
Thank you
Any solution for this? the suggestion at excelguru.ca didn't work for me because I'm conecting web>json (just as this topic) ... the excelguru.ca is about standard local files...
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |