Creating dataflows in Power BI - Practice Exercises

Challenge - 5 Problems

🧠 Conceptual

intermediate

Purpose of Dataflows in Power BI

What is the main purpose of creating dataflows in Power BI?

A To store raw data without any processing for archival purposes only.

B To build visual dashboards directly without any data transformation.

C To replace Power Query Editor in Power BI Desktop completely.

D To create reusable data transformation logic that can be shared across multiple reports and datasets.

💡 Hint

Think about how dataflows help with data preparation and reuse.

Dataflows allow you to prepare and transform data once and reuse it in many reports and datasets, improving consistency and efficiency.

❓ dax_lod_result

intermediate

Calculate Total Sales Using Dataflow Table

Assume you have a dataflow named SalesDataflow with a table Sales containing a column Amount. Which DAX measure correctly calculates the total sales amount?

A Total Sales = SUM('SalesDataflow_Sales'[Amount])

B Total Sales = SUM(SalesDataflow[Amount])

C Total Sales = SUM('Sales'[Amount])

D Total Sales = SUM(SalesDataflow.Sales[Amount])

💡 Hint

Remember how dataflow tables are referenced in Power BI datasets.

When using dataflow tables in Power BI, the table name is prefixed with the dataflow name and an underscore, like 'SalesDataflow_Sales'.

❓ visualization

advanced

Best Visualization for Dataflow Refresh Status

You want to create a dashboard visual in Power BI to show the refresh status of multiple dataflows over the past week. Which visualization type is best suited to clearly show daily refresh success or failure for each dataflow?

A A clustered bar chart showing total refresh counts per dataflow.

B A matrix visual with dataflows as rows and dates as columns showing refresh status icons.

C A pie chart showing percentage of successful refreshes overall.

D A line chart showing refresh duration over time.

💡 Hint

Consider which visual best shows status per day per dataflow in a grid format.

A matrix visual can display dataflows on rows and dates on columns, allowing you to show refresh success or failure clearly for each day and dataflow.

🔧 Formula Fix

advanced

Troubleshooting Dataflow Refresh Failure

You created a dataflow that connects to an external SQL database. The dataflow refresh fails with an authentication error. Which of the following is the most likely cause?

A The dataflow query contains syntax errors in Power Query M language.

B The Power BI service is down and cannot refresh any dataflows.

C The credentials for the SQL database connection in the dataflow are incorrect or expired.

D The dataflow is missing a primary key in its tables.

💡 Hint

Authentication errors usually relate to connection credentials.

Authentication errors during dataflow refresh typically mean the credentials used to connect to the data source are invalid or expired and need to be updated.

❓ data_modeling

expert

Optimizing Dataflows for Large Datasets

You manage a dataflow that processes a very large dataset. To improve performance and reduce refresh time, which approach is best when designing the dataflow?

A Split the dataflow into multiple linked dataflows, each handling a subset of the data, and then combine them in the dataset.

B Load all raw data into a single dataflow and perform all transformations there without splitting.

C Avoid using incremental refresh and always do full refreshes to ensure data accuracy.

D Use calculated columns in the dataflow instead of measures in the dataset to speed up refresh.

💡 Hint

Think about modular design and reusability for large data.

Splitting large datasets into multiple linked dataflows allows parallel processing and easier maintenance, improving refresh performance.