Power BI
What It Is
The Power BI skill helps your assignments work effectively with Power BI datasets and reports. When this skill is enabled, your assignment follows a reliable protocol for schema discovery, DAX query construction, and data export—reducing errors and producing accurate results from your Power BI data.
What It Can Do
Schema Discovery
Discover workspaces, reports, and datasets in your Power BI account
Retrieve exact table names, column names with types, and measures before writing any queries
DAX Query Execution
Write correct DAX queries using proper syntax and identifier rules
Perform aggregations, filters, and calculations across related tables
Handle grouped aggregations, top-N analysis, and year-over-year comparisons
Data Export
Export dataset results to CSV for further analysis
Process exported data using Python with pandas and numpy
Handle large datasets by applying appropriate row limits and filters
Error Handling
Verify query results for missing rows or silent data drops
Retry queries with corrected syntax when errors occur
Identify and handle edge cases like blank rows in aggregations
When to Use It
Enable the Power BI skill when your assignment needs to:
Query Power BI datasets and retrieve specific metrics or KPIs
Aggregate or filter data across multiple related tables
Export data for statistical analysis or reporting
Compare values across time periods or segments
Compile Power BI data into reports, emails, or summaries
Example Tasks
"Pull total revenue by region from the Sales dataset"
"Get the top 10 products by revenue from last quarter"
"Compare this year's performance against last year by category"
"Export the Stores table and calculate average sales per store"
"Summarize KPIs from the Exec Dashboard dataset for the weekly email"
How to Use
Open the assignment you want to configure
In the assignment settings, find the Skills section
Select the Power BI skill
Save your changes
Your assignment will automatically apply the Power BI query protocol whenever it works with Power BI data.
Things to Know
This skill works with the Microsoft Power BI connection—you need the connection set up before using this skill
The skill instructs your assignment to always discover the schema before querying, which reduces errors from incorrect table or column names
DAX column and table names are case-sensitive; the skill enforces correct quoting rules
Data exports are limited to 100,000 rows per query; the skill applies filters or TOPN when needed for large tables
Last updated