{"id":2453,"date":"2022-08-13T10:55:38","date_gmt":"2022-08-13T15:55:38","guid":{"rendered":"http:\/\/ninmonkeys.com\/blog\/?p=2453"},"modified":"2022-09-11T09:24:58","modified_gmt":"2022-09-11T14:24:58","slug":"experiments-of-2022-08","status":"publish","type":"post","link":"https:\/\/ninmonkeys.com\/blog\/2022\/08\/13\/experiments-of-2022-08\/","title":{"rendered":"Experiments of 2022-08"},"content":{"rendered":"\n

Query to Summarize All Queries<\/h2>\n\n\n\n

Summarize.Query.pq<\/a><\/p>\n\n\n\n

\"Summarize<\/figure>\n\n\n\n

Using Inline Images and SVG in a Power BI Table<\/h2>\n\n\n\n

With the column set to Image Url, you’re able to<\/p>\n\n\n\n

  • use an external image like https:\/\/www.fakeurl.com\/image.png <\/li>
  • or output a svg<\/code> image programmatically, by placing logic in a measure<\/li>
  • or embedded a raw a .png<\/code> image into the model\/report itself
    • First encode the image Base64<\/strong><\/li>
    • Save that text in a table<\/li>
    • Finally create a measure that prefixes the text with<\/li><\/ul><\/li><\/ul>\n\n\n\n
      [Inline Png ] := \n      "data:image\/png;base64, " & SelectedValue( [ColumnWithText] )<\/code><\/pre>\n\n\n\n
      • \"\"<\/figure><\/li><\/ul><\/figure>\n\n\n\n
        Recent Discord Api<\/h2>\n\n\n\n
        \/*\nnote: make sure your GUIDs are strings, why?\nbecause javascript does not have an integer type, so it has to squeeze\ninside a floating point, see: <https:\/\/discord.com\/developers\/docs\/reference#snowflakes>\n*\/\nconst cfg = {\n    "GuildId": "180528040881815552",\n    "Channel": "490008213056389120",\n}\n\nconst apiUri = {\n    "prefix": "https:\/\/discord.com\/api\/v9\/",\n    "activeThreads": `guilds\/${ cfg.GuildId }\/threads\/active`, \/\/ bot only endpoint\n    "channelMessage50": `channels\/${ cfg.Channel }\/messages?limit=50`\n}\n\n\/\/ apiUri.curUri = apiUri.channels\napiUri.curUri = apiUri["channelMessage50"]\n\nconsole.log(`Cur uri: "${ apiUri.curUri }"`)\ncurUri = `${ apiUri.prefix }${ apiUri.curUri }`\n\nawait fetch(\n    curUri, lastOpt\n).then((r) => r.json()\n).then((x) => console.log(JSON.stringify(x)))<\/code><\/pre>\n\n\n\n
        • run Discord in the browser<\/li>
        • open web dev console<\/li>
        • take an existing request -> copy as Fetch()<\/code> or curl<\/li>
        • saved those headers as lastOpt<\/code><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"
          Query to Summarize All Queries Summarize.Query.pq Using Inline Images and SVG in a Power BI Table With the column set to Image Url, you’re able to use an external image like https:\/\/www.fakeurl.com\/image.png or output a svg image programmatically, by placing logic in a measure or embedded a raw a .png image into the model\/report itself […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[72,50],"tags":[73,6,4,116],"_links":{"self":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2453"}],"collection":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/comments?post=2453"}],"version-history":[{"count":6,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2453\/revisions"}],"predecessor-version":[{"id":2476,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2453\/revisions\/2476"}],"wp:attachment":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/media?parent=2453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/categories?post=2453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/tags?post=2453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}