Dataflow entities in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Dataflow Entities in Power BI

Which statement best describes a dataflow entity in Power BI?

A A dataflow entity is a Power BI desktop file that contains all report pages and visuals.

B A dataflow entity is a reusable table created in Power BI service that stores data transformed using Power Query.

C A dataflow entity is a DAX measure used to calculate aggregated values in reports.

D A dataflow entity is a visual report element that displays data from multiple datasets.

💡 Hint

Think about where dataflows store and prepare data before it is used in reports.

Dataflow entities are tables created and stored in Power BI service using Power Query. They allow data to be reused across multiple reports and datasets.

❓ dax_lod_result

intermediate

Calculating Row Count in a Dataflow Entity

Given a dataflow entity named SalesData with a column OrderID, which DAX measure correctly counts the number of unique orders?

A OrderCount = DISTINCTCOUNT(SalesData[OrderID])

B OrderCount = COUNT(SalesData[OrderID])

C OrderCount = COUNTROWS(SalesData)

D OrderCount = SUM(SalesData[OrderID])

💡 Hint

Count unique order IDs, not just total rows.

DISTINCTCOUNT counts unique values in a column. COUNT counts non-blank values but not unique. SUM adds numbers, and COUNTROWS counts rows of a table, not a column.

❓ visualization

advanced

Best Visualization for Dataflow Entity Trends

You have a dataflow entity with daily sales data. Which visualization best shows sales trends over time?

A A table listing sales amount and order count.

B A pie chart showing sales amount by product category.

C A stacked bar chart showing sales amount by region and product.

D A line chart showing sales amount by date.

💡 Hint

Think about which chart type clearly shows changes over time.

Line charts are best for showing trends over time because they display continuous data points connected by lines.

❓ data_modeling

advanced

Optimizing Dataflow Entities for Performance

Which approach improves performance when designing dataflow entities for large datasets?

A Use calculated columns in reports instead of in dataflow entities.

B Load all raw data without filtering to keep data complete.

C Filter data early in Power Query to reduce rows before loading.

D Avoid using incremental refresh in dataflows.

💡 Hint

Reducing data size early helps speed up processing.

Filtering data early in Power Query reduces the amount of data loaded and processed, improving performance. Loading all data or avoiding incremental refresh can slow down processing.

🔧 Formula Fix

expert

Troubleshooting Dataflow Entity Refresh Failure

A dataflow entity refresh fails with the error: "Data source credentials are invalid." Which option is the most likely cause?

A The credentials used to connect to the data source have expired or changed.

B The dataflow entity has a syntax error in its Power Query steps.

C The Power BI report connected to the dataflow is corrupted.

D The dataflow entity contains too many columns causing timeout.

💡 Hint

Think about what "credentials" refers to in data refresh.

Invalid credentials errors usually mean the username or password used to access the data source is incorrect or expired. Syntax errors or report corruption cause different errors.