Advanced Power BI Custom Visuals: Options & Tradeoffs
Power BI is strongest for its built-in Power Query ETL and powerful Vertipaq tabular engine, but it’s not renowned as the crispest visualization tool on the commercial BI scene (most… Read more »
I’m Officially An International Man of Mystery!
I recently had a blast talking with Rob Collie and Tom LaRock on their Raw Data podcast, covering some of my eclectic obsessions from international arbitrage and public deficits to… Read more »
How to Hijack Power BI Styles to Apply Your Own
In a previous entry we saw how to use Cascading Style Sheets with Power BI’s HTML Content visual do apply dynamic visual effects outside what’s commonly expected within the platform…. Read more »
How to Pimp Your Power BI Reports with Dynamic CSS in the HTML Content Custom Visual
Microsoft Power BI rose to its leading position in the BI market on the back of its top-shelf PowerQuery self-service ETL and VertiPaq in-memory engine as well as its familiarity… Read more »
Home LAN + NAS Administration & Security 101 and Beyond for Remote Work and Media Management
I’ve had NAS devices for almost 15 years and have grown our local network to 40+ devices for a family of 4, as the PCs, laptops, smart TVs, tablets, phones,… Read more »
How to Bend Plex to Your Will to Handle Complex Libraries Without Losing Your Mind
It’s very easy to get started with Plex to handle a simple movie or TV show collection, but as you add different types of content and grow your libraries, it… Read more »
Refreshing Power BI Datasets & Dataflows with APIs and Power Automate
When Microsoft introduced Power BI dataflows at the end of 2018 to separate no/low code cloud ETL from BI modeling and visualization, many people were initially confused about how refreshes… Read more »
Use the Schema Tools in Microsoft Dataflows to Manipulate Columns
A new view (pictured above) was recently spotted recently “in the wild” in Power BI dataflows (credit for the find: Dave Rujiter). I can’t find anything about it in the… Read more »
Third-Party Tools to Ease Power BI Development and Increase Analyst Productivity
While some cloud BI tools such as Amazon QuickSight do all their authoring in the browser, Microsoft chose to develop a dedicated client creatively named Power BI Desktop. Its initial… Read more »
Spreadsheets Get Smarter About Structured Data, At A Steep Price
I find it interesting that Microsoft and Google have chosen to gate their latest data-driven improvements to their spreadsheets behind their most expensive enterprise licenses. These new features are great,… Read more »