1) Click Data, Get Data, From Other Sources, Blank Query - You might be able to use "From Web", however Blank Query gives you more options 2) Enter The Advanced Editor and Strucutre it as follows... let Source = Json.Document(Web.Contents("https://localhost:7056/ap/endpoint" , [Headers = [Accept="application/json"]])), TableFromRecords = Table.FromRecords(Source) in TableFromRecords
<% ... %> – Code Block Executes C# code but does not render any output to the page. Useful for logic (e.g., declaring variables, loops). <% int x = 5; %> <%= ... %> – Output (Escaped) Evaluates the expression and writes the result to the page . The output is HTML-encoded (i.e., special characters are escaped). <%= "<b>Hello</b>" %> <!-- Outputs: <b>Hello</b> --> In DevExpress, it actually outputs Hello, in bold 3. <%- ... %> – Output (Unescaped) Writes the result to the page without HTML encoding .