Pauls Blog

  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: &lt;b&gt;Hello&lt;/b&gt; --> In DevExpress, it actually outputs Hello, in bold 3. <%- ... %> – Output (Unescaped) Writes the result to the page without HTML encoding .