Power BI workflow (get data, transform, visualize, share) - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Identify the correct sequence of Power BI workflow steps

Which of the following sequences correctly represents the typical Power BI workflow from start to finish?

A 1,2,3,4

B 2,1,3,4

C 1,3,2,4

D 3,1,2,4

💡 Hint

Think about what you do first: getting data or making visuals?

The correct workflow starts with getting data, then transforming it, creating visuals, and finally sharing the reports.

❓ dax_lod_result

intermediate

Calculate total sales per product ignoring filters

Given a sales table with columns Product and SalesAmount, which DAX measure correctly calculates total sales for each product ignoring any report filters?

Power BI

Total Sales All Products = CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales[Product]))

A SUMX(ALL(Sales), Sales[SalesAmount])

B CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales[Product]))

C SUM(Sales[SalesAmount])

D CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[Product] = EARLIER(Sales[Product])))

💡 Hint

Use ALL() to ignore filters on the product column.

Option B uses CALCULATE with ALL(Sales[Product]) to remove filters on Product and sum all sales per product.

❓ visualization

advanced

Choose the best visualization for showing sales trends over time

You want to show how sales change month by month over the last year. Which visualization type is best suited for this purpose?

A Stacked Bar Chart

B Scatter Plot

C Pie Chart

D Line Chart

💡 Hint

Think about which chart shows changes over time clearly.

Line charts are ideal for showing trends over time because they connect data points in a continuous flow.

🔧 Formula Fix

advanced

Identify the error in this Power Query M code snippet

What error will this Power Query M code produce?

let
  Source = Excel.Workbook(File.Contents("data.xlsx")),
  Sheet1 = Source{[Name="Sheet1"]}[Content],
  ChangedType = Table.TransformColumnTypes(Sheet1,{{"Date", type date}, {"Sales", type number}})
in
  ChangedType

A No error, code runs successfully

B Error: The indexer [Name="Sheet1"] does not exist in Source

C Error: File.Contents is missing a closing parenthesis

D Error: Table.TransformColumnTypes has wrong syntax for type conversion

💡 Hint

Check if the syntax and references are correct.

The code correctly loads an Excel file, accesses Sheet1, and changes column types without syntax errors.

🎯 Scenario

expert

Optimize report sharing for a large organization

Your company has thousands of users who need access to Power BI reports. You want to share reports efficiently while controlling access by department. Which approach is best?

A Publish reports to Power BI Service and share individual report links with each user

B Embed reports in a public website without authentication

C Use Power BI Apps with workspace roles and row-level security to control access by department

D Export reports to PDF and email to all users monthly

💡 Hint

Consider scalability and security for many users.

Power BI Apps combined with workspace roles and row-level security allow scalable, secure sharing tailored by department.