Tim
Community@InsightfulAnalytics · Sydney
Finance guy turned Power BI nerd, love DAX, M-Code SQL, VBA, Vega Lite. I came to share my creations.
Agent Skills by Tim
Showing 43 vetted skills indexed across 1 GitHub repositories.
InsightfulAnalyticspbip
Guides Power BI Project (PBIP) structure, PBIX extraction, and cross-cutting rename operations.
InsightfulAnalyticspbir-format
Author and validate Power BI Enhanced Report (PBIR) JSON metadata files.
InsightfulAnalyticstmdl
Author and edit TMDL files for Power BI semantic models in PBIP projects.
InsightfulAnalyticsfabric-cli
Manage Microsoft Fabric workspaces, items, and data programmatically with the fab CLI.
InsightfulAnalyticsconnect-pbid
Connects to Power BI Desktop's local Analysis Services instance via TOM and ADOMD.NET for model queries and modifications.
InsightfulAnalyticsexecuting-spark
Execute PySpark code on Microsoft Fabric Spark compute via ephemeral Livy sessions.
InsightfulAnalyticsusing-duckdb
Query Fabric lakehouse and warehouse Delta tables using DuckDB locally or in notebooks.
InsightfulAnalyticste2-cli
Automates Tabular Editor 2 CLI operations for model deployment, scripting, and BPA analysis.
InsightfulAnalyticste-docs
Search Tabular Editor documentation and validate TE3 configuration files including .tmuo and Preferences.json.
InsightfulAnalyticsc-sharp-scripting
Write and execute C# scripts against Power BI semantic models using Tabular Editor.
InsightfulAnalyticsbpa-rules
Generate and validate Best Practice Analyzer rules for Power BI semantic models.
InsightfulAnalyticste-cli
Manage Power BI and Analysis Services semantic models from the terminal with the Tabular Editor CLI.
InsightfulAnalyticsdax-standard
Write readable, debuggable DAX measures using a table-first pattern with VARs and X-aggregators.
InsightfulAnalyticssemantic-model
Design, build, refresh, and review Power BI tabular semantic models via the te CLI.
InsightfulAnalyticslineage-analysis
Trace downstream reports connected to Power BI semantic models across Fabric workspaces.
InsightfulAnalyticsrefresh-semantic-model
Trigger, monitor, and troubleshoot Power BI semantic model refreshes via the Enhanced Refresh REST API.
InsightfulAnalyticspower-query
Author, validate, and test Power Query M expressions in semantic model partitions.
InsightfulAnalyticsmodel-change
Orchestrates end-to-end semantic model changes in local PBIP projects via TMDL edits and validation.
InsightfulAnalyticsstandardize-naming-conventions
Audits and renames tables, columns, and measures in TMDL-based Power BI semantic models.
InsightfulAnalyticsdate-table
Adds a 58-column DimDate table and date-selection measure to PBIP semantic models via TMDL injection.
InsightfulAnalyticsdax-optimisation
Diagnose and optimize slow DAX queries in Power BI semantic models using trace analysis.
InsightfulAnalyticspaginated-report
Author, validate, publish, and render Power BI paginated reports in RDL format.
InsightfulAnalyticsr-visuals
Creates R script visuals with ggplot2 for Power BI PBIR reports.
InsightfulAnalyticsdeneb-visuals
Author Vega and Vega-Lite specs for Deneb custom visuals in Power BI PBIR reports.
Frequently Asked Questions About Tim
FAQPage SchemaWhat tasks can I accomplish with InsightfulAnalytics's Power BI skills?▼
You can build and edit PBIP projects and PBIR reports, author DAX measures and Power Query M partitions, convert BIM to TMDL, create paginated RDL reports, build Deneb Vega-Lite and SVG visuals, run BPA best-practice audits, optimize slow DAX, refresh semantic models, and administer Fabric tenant settings and capacities.
Who are these Power BI and Fabric skills designed for?▼
They target BI developers, analytics engineers, and semantic model authors working in Power BI Desktop, Tabular Editor 2/3, and Microsoft Fabric. Finance and reporting professionals building P&L matrices, executive dashboards, and paginated invoice reports benefit most, alongside admins managing workspaces, lineage, and tenant settings.
How do the skills interact with Power BI Desktop and Fabric at runtime?▼
Skills connect to Power BI Desktop's local Analysis Services instance via TOM and ADOMD.NET over PowerShell, drive the Fabric CLI (fab) for workspace operations, execute PySpark on ephemeral Livy sessions, and query OneLake Delta tables with DuckDB. The pbir CLI and Desktop Bridge reload canvases and screenshot pages for visual verification.
What are the prerequisites for using these semantic model skills?▼
You need Power BI Desktop or a Fabric workspace, plus Tabular Editor 2/3 or the cross-platform te CLI for model operations. TMDL editing requires a PBIP project structure; C# scripting requires Tabular Editor; Spark execution requires a Fabric capacity; and Desktop screenshot features require Windows with external tool access enabled.
Can these skills enforce modeling standards and best practices?▼
Yes. The bpa-rules and suggest-rule skills generate and validate Best Practice Analyzer rules, standardize-naming-conventions cleans up measure and column names across TMDL models, dax-standard enforces a readable VAR-based measure style, and review-report plus audit-tenant-settings assess report quality and Fabric tenant configuration.