Skip to main content

Posts

How to Get Data from an API into Excel

  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
Recent posts

Devexpress <% Tags

<% ... %> – 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 .

EntraID App - Require Admin Consent to allow user

Admin Consent - Allowing a User to Authenticate to an EntraID app  The admin consent I'm talking about below is simply authentication.  It is different to the admin consent required under API Permissions.  In API Permissions, we're typically allowing the app to make changes to user accounts and/or work across any user.   In this example, we are simply allowing the user to login to the app, when the admin normally needs to provide consent for authenticating to the app.  This is becoming more common as Enterprise Admin lock down what users can do with their company accounts. This admin consent is required when adminstrators prevent users from authenticating to an external application using EntraID.  1) From the App Registration, select Overview, then the Managed Application itself.  2) From the Managed Application, select Security, Permissions, and enable Admin Consent. 

by pass microsoft account when setting up Windows 11

  Use Command Prompt to Skip Microsoft Account When you're prompted to sign in with a Microsoft account, press Shift + F10 to open Command Prompt. Type the following command to launch the local account setup: oobe\bypassnro The system will reboot, and after rebooting, you’ll have the option to set up a local account without a Microsoft account.

PowerBI Get Tables enabled in a PowerBi Report

 1) Unpack the pbix file (ie: unzip it)  2) Find the DiagramLayout.json file 3) The table name will be in a node called  nodeIndex                 {                     "location" : {                         "x" : 588 ,                         "y" : 0                     },                     "nodeIndex" : "CALENDAR" ,                     "size" : {                         "height" : 206 ,                         "width" : 254                     }, ...

CLONE a table in Snowflake

  Clone a Table in Snowflake  So simple,  CREATE TABLE TableName_Clone CLONE OriginalTableName To restore a table at a specific timestamp  CREATE TABLE  TableName_Clone   CLONE  OriginalTableName AT  (TIMESTAMP => TO_TIMESTAMP_TZ('11/04/2024 00:00:00', 'dd/mm/yyyy hh24:mi:ss'));

IEC 60320 Power Cords

  Mains Interconnect Diagram Pin spacing, centres (mm) Earth contact Appliance class Rewirable connector allowed? Max. current (A) Max. pin temp. (°C) Polarized Remarks and example uses Connector (Female) Appliance inlet (Male) Plug connector (Male) Appliance outlet (Female) C1 C2 - - 6.6 No II No 0.2 70 No C3 C4 - - 10 No II 2.5 70 Yes C5 C6 A B 10 (H) 4.5 (V) Yes I No 2.5 70 Yes Commonly referred to as a "clover-leaf" or "Mickey Mouse" connector  C7 C8 C D 8.6 No II No 2.5 70 No There is a similar polarized connector,  but this is not part of the standard. C9 C10 - - 10 No II No 6 70 No This kind of coupler is used by  Roland Corporation  and  Revox   for synthesizer and drum-computer models and  hi-fi equipment.  Was also by  Marantz C11 C12 - - 10 No II 10 70 Yes Similar to C9 with a slot in the connector, withdrawn from standard. C13 C14 E F 14 (H) 4 (V) Yes I Yes 10 70 Yes C15 C16 M N 14 (H) 4 (V) Yes I Yes 10 120 Yes For use in hi...