Pauls Blog

Sometimes, you want to concat a few fields together and have a separator, but you only want the separator when the next field is not empty and not blank ARRAY_CONSTRUCT creates an array from the fields ARRAY_COMPACT removes blanks and "undefined" ARRAY_TO_STRING converts the array to a single string, with a separator SELECT PERSONID , ARRAY_TO_STRING ( ARRAY_COMPACT ( ARRAY_CONSTRUCT ( NULLIF ( ADRLINE1 , '' ), NULLIF ( ADRLINE2 , '' ), NULLIF ( ADRLINE3 , '' ) ) ), ', ' ) AS ADDRESS FROM PERSONTABLE ;

  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 .

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. 

  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.

 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                     }, ...