GetPQ: A Very Bare-Bones Tool for Power Query
So a while back I was playing around with a Power Query Shared Library. I got pretty far, but I...
Archive and QA PBI Workspaces with PowerShell
I was working on something where I had to archive and review workspace content. I wanted to do it quickly...
Formatting M Code with Power Automate Desktop
Previously, I had been using Github Copilot to help me generate code for a Visual Basic app in Visual Studio....
Sending HTML Tables from Power BI
(and some ramblings about Copilot and SVGs) At times, you may get requests for updates about certain metrics that are...
TheColorAPI + PowerQuery = Color Scheme
I was looking at APIs and found a very cool one: The Color API. It is a nice API that...
PowerShell, ImportExcel, and Formatting DAX?
ImportExcel is a really cool PowerShell module. I’ve used it before to export data from SQL Server and then upload...
- DAX / PowerShell / VBA
- Read More
Switch with Power Query: Final Boss Battle
I will admit that I have been a little preoccupied with this problem. This all started with me watching one...
Automatically Round Off Number Columns with Power Query
I was working on additional functions for the Power Query Shared Library and thought about routine things that many people...
Dynamically Remove Characters with Character.ToNumber()
When I was writing more VBA, I found a post somewhere that showed how to pull out specific groups of...
My Own #Shared M Library: Take 1
I’ve been trying to write an M extension. I should distinguish this by saying I am not trying to write...