What is power-bi-optimization-skill?

This repository contains a skill you can install into GitHub Copilot to get specialized help with Power BI. Power BI is Microsoft's tool for creating data dashboards and reports from various data sources. GitHub Copilot is an AI assistant built into code editors. This skill extends that assistant so that when you ask questions about Power BI topics in your editor, the responses draw on a structured set of expert guidance rather than generic AI knowledge. The skill is organized in a hub-and-spoke structure. A central component, called the hub, handles your initial question and decides which specialist area applies. It then routes the question to one of five specialist modules, each covering a different part of Power BI: DAX formulas, semantic model design, report performance, Power Query data loading, and row-level security. Each specialist has a collection of optimization patterns built in, amounting to over 47 patterns total across all areas. DAX is Power BI's formula language for calculations and aggregations. The DAX specialist covers how to write formulas that run faster, how to handle context transitions (a concept specific to how DAX evaluates formulas inside tables and filters), and how to benchmark formulas statistically to measure actual improvements. The model design specialist covers topics like how to structure your data tables, when to use Import mode versus DirectQuery mode (two different ways Power BI can connect to data), and how to handle complex relationships between tables. Import mode loads data into memory for fast queries, DirectQuery sends queries directly to the source database each time, which is slower but avoids loading large datasets. The report performance specialist addresses things like how many visuals to put on a page and how layout choices affect loading speed. The Power Query specialist covers how data gets loaded and transformed before it reaches your reports, including making sure transformations happen at the database level rather than in Power BI's own engine. The security specialist covers row-level security, which is how you restrict which rows of data different users can see. Installation is done through the GitHub CLI or by copying files to a local directory. After installation you invoke the skill by typing its name in a Copilot chat. The full README is longer than what was shown.