PowerQuery has metadata that you don’t normally see. For example, take the function Table.FromRecords Create a new blank query, and set the value to a function’s name. When you reference a function without arguments or parenthesis, it displays documentation. ( It’s mostly the same as the online docs ) Where does this come from? A […]
Power BI / Power Query Things to note options is an record, when used this way it’s similar to Python’s kwargs Merging two records with update the existing fields, adding new fields, if they do not yet exist (in PowerQuery) the order of steps don’t change the final result (order of execution is the same) […]
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 […]
Where is the default settings.json or keybindings.json ? There isn’t one, because it’s dynamically generated. When you run run the ‘default settings’ command, it builds a new one — this means it’s always up to date. It includes settings from all enabled addons. Command Palette: The Only Hotkey You Need to Remember. Can’t remember what […]
FdFind, Ansi Colors with Group-Object Using wt‘s Parameters Nested Formatting in Powershell CLI bat to preview results Regex Lazy vs Greedy Expressions Using CSS Selectors Autocomplete changes based on the first Argument Parsing Stdout Whitespace Using Format-ControlChar Grouping On Errors Type Resolution Is Scoped
The Documentation Is Great Check out the examples for Filter , you can experiment without configuring a data source Top Level, New To Apps entry point: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/ Sample Data Without a Data Source – Declaring Inline Tables Step1: Choose Insert -> Button. Step2: Set the button’s OnSelect property to this. Step3: Alt left click the […]
File Selection CLI Revisiting BASH See more Detect Valid Values for gh –json — then Fzf filter them PowerApps: Visualize filter in Queries Is there a way to add columns Programically to many queries? Labeled Summary of all queries VS Code Syntax Highlighting when $null + 3 + 3 = 12 Random Power Query Power […]
Declaring optional parameters in custom functions, combine multipleWeb.Contents queries, without refresh errors. Using Html.Table with custom CSS Selectors
Discord Web Hooks are easier than you’d think. It uses a regular `HTTP` web request . Step1: Creating your webhook url Go to: Server Settings -> Integrations -> View WebhooksThen click create webhook. Step2: Invoke-RestMethod Success! Docs There are optional webhook arguments to customize the output: https://discord.com/developers/docs/resources/webhook#execute-webhook Comparison with curl I tried making curl easier […]
The output of diff -q path1 path2 is pretty verbose. This function Converts full paths to relative Differences are red. Missing ‘diff’ ? If git is installed, you may need to update your %PATH% environment variable. Stand-Alone function Compare-Directory This is an isolated version of <a href="https://github.com/ninmonkey/Ninmonkey.Console">Ninmonkey.Console: Compare-Directory</a> . I removed all dependencies except coloring […]
Sometimes you’ll need to run a command with the same input with different logic. This can be a hassle using a slow command like Get-ADUser or Get-ChildItem on a lot of files like ~ (Home) with -Depth / -Recurse PowerShell 7.0+ Powershell 7 added the Ternary Operator, and several operators for handling $null values. All […]
Power BI Discord asked the question:> How do you use duplicate keys, and dynamic urls with <a href="https://docs.microsoft.com/en-us/powerquery-m/web-contents">Web.Contents</a> ? (They were using a web API that required duplicate keys) After I wrote this, Chris Webb found an easier solution. Requirements You can’t use a regular record because keys must be distinct. Query = [ Key1 […]
Why doesn’t the original [Num] * 2 work? Powerquery does not know what type will be returned by your function. That’s because each is by definition a function that returns type any See More see the each expression in the Lexical Grammar Docs on Power Query each functions
Power BI AI using PowerShellAI
PowerQuery has metadata that you don’t normally see. For example, take the function Table.FromRecords Create a new blank query, and set the value to a function’s name. When you reference a function without arguments or parenthesis, it displays documentation. ( It’s mostly the same as the online docs ) Where does this come from? A […]
Where is the default settings.json or keybindings.json ? There isn’t one, because it’s dynamically generated. When you run run the ‘default settings’ command, it builds a new one — this means it’s always up to date. It includes settings from all enabled addons. Command Palette: The Only Hotkey You Need to Remember. Can’t remember what […]
FdFind, Ansi Colors with Group-Object Using wt‘s Parameters Nested Formatting in Powershell CLI bat to preview results Regex Lazy vs Greedy Expressions Using CSS Selectors Autocomplete changes based on the first Argument Parsing Stdout Whitespace Using Format-ControlChar Grouping On Errors Type Resolution Is Scoped
Experiments: DAX, Pwsh, VS Code
Dax Web App ( From sqlbi.com )
Word wrapping text using
Declaring
Discord Web Hooks are easier than you’d think. It uses a regular `HTTP` web request . Step1: Creating your webhook url Go to: Server Settings -> Integrations -> View WebhooksThen click create webhook. Step2: Invoke-RestMethod Success! Docs There are optional webhook arguments to customize the output: https://discord.com/developers/docs/resources/webhook#execute-webhook Comparison with curl I tried making curl easier […]
The output of diff -q path1 path2 is pretty verbose. This function Converts full paths to relative Differences are red. Missing ‘diff’ ? If git is installed, you may need to update your %PATH% environment variable. Stand-Alone function Compare-Directory This is an isolated version of <a href="https://github.com/ninmonkey/Ninmonkey.Console">Ninmonkey.Console: Compare-Directory</a> . I removed all dependencies except coloring […]
Sometimes you’ll need to run a command with the same input with different logic. This can be a hassle using a slow command like Get-ADUser or Get-ChildItem on a lot of files like ~ (Home) with -Depth / -Recurse PowerShell 7.0+ Powershell 7 added the Ternary Operator, and several operators for handling $null values. All […]
Why doesn’t the original [Num] * 2 work? Powerquery does not know what type will be returned by your function. That’s because each is by definition a function that returns type any See More see the each expression in the Lexical Grammar Docs on Power Query each functions