power-bi-diagnostics

# Power BI Diagnostics Skill Troubleshoot performance, trace queries, and verify the pbi-cli environment. ## Prerequisites ```bash pipx install pbi-cli-tool pbi-cli skills install pbi connect ``` ## Environment Check ```bash # Verify pythonnet and .NET DLLs are installed pbi setup # Show detailed environment info (version, DLL paths, pythonnet status) pbi setup --info pbi --json setup --info # Check CLI version pbi --version ``` ## Quick Troubleshooting If pbi-cli isn't working, run these checks in order: ```bash # 1. Is pbi-cli installed correctly? pbi --version pbi setup --info # 2. Is Power BI Desktop running with a model open? pbi connect # 3. Is the connection still alive? pbi connections last # 4. Can you query the model? pbi dax execute "EVALUATE ROW(\"test\", 1)" ``` ## Model Health Check ```bash # Quick model overview pbi --json model get # Object counts (tables, columns, measures, relationships, partitions) pbi --json model stats # List all tables with column/measure counts pbi --json table list ``` ## Query Tracing Capture diagnostic events during DAX query execution: ```bash # Start a trace pbi trace start # Execute the query you want to profile pbi dax execute "EVALUATE SUMMARIZECOLUMNS(Products[Category], \"Total\", SUM(Sales[Amount]))" # Stop the trace pbi trace stop # Fetch captured trace events pbi --json trace fetch # Export trace events to a file pbi trace export ./trace-output.json ``` ## Cache Management ```bash # Clear the formu...