Power BI diagnostics skill for the pbi-cli command-line tool: environment check, model health and statistics, tracing and profiling of slow DAX queries, cache management and model audit. Third-party skill in English, requires pbi-cli to be installed.
Power BI diagnostics skill for the pbi-cli command-line tool: environment check, model health and statistics, tracing and profiling of slow DAX queries, cache management and model audit. Third-party skill in English, requires pbi-cli to be installed.
This resource is maintained by i2Business consultants and updated whenever the systems it covers change. It works with the other building blocks in the catalog and can be tailored to your context as part of a support engagement.
Excerpt: the procedure for profiling a slow query with pbi-cli. power-bi-diagnostics/SKILL.md
pbi dax clear-cache # clear the cache for a clean test pbi trace start # start the trace pbi dax execute "EVALUATE ..." --timeout 300 pbi trace stop pbi trace export ./slow-query-trace.json pbi --json trace fetch # read back the captured events
Our consultants tailor this resource to your use cases and train your teams in its day-to-day use.
Talk to a consultant