Creating dataflows in Power BI - Quick Revision & Summary

Recall & Review

beginner

What is a dataflow in Power BI?

A dataflow is a collection of tables created and managed in the Power BI service. It helps prepare and transform data before loading it into reports or dashboards.

beginner

Why use dataflows instead of importing data directly into Power BI Desktop?

Dataflows allow you to centralize data preparation, reuse data across multiple reports, and keep data refreshed in one place, saving time and ensuring consistency.

beginner

Which tool do you use to create and edit dataflows in Power BI?

You use Power Query Online inside the Power BI service to create and edit dataflows, similar to Power Query in Power BI Desktop.

intermediate

What is the main benefit of using dataflows for data refresh?

Dataflows can refresh data independently from reports, so multiple reports can use the same updated data without refreshing each report separately.

intermediate

Can dataflows connect to multiple data sources? Give an example.

Yes, dataflows can connect to many sources like Excel files, SQL databases, and web APIs to combine and transform data in one place.

What is the primary purpose of a dataflow in Power BI?

A To prepare and transform data centrally before use in reports

B To create visual charts and graphs

C To write DAX formulas

D To schedule report refreshes only

Dataflows are designed to prepare and transform data centrally, making it reusable for reports.

Where do you create and manage dataflows in Power BI?

A Power BI Desktop

B SQL Server Management Studio

C Power BI Service using Power Query Online

D Excel

Dataflows are created and managed in the Power BI Service using Power Query Online.

Which of these is NOT a benefit of using dataflows?

A Direct creation of dashboards

B Reuse of data across reports

C Centralized data preparation

D Independent data refresh

Dataflows do not create dashboards directly; they prepare data for use in reports and dashboards.

Can dataflows connect to multiple data sources at once?

A Only Excel files

B No, only one source per dataflow

C Only databases

D Yes, they can combine data from many sources

Dataflows can connect to and combine data from multiple sources like Excel, databases, and web APIs.

What happens when you refresh a dataflow?

A Reports refresh but dataflow does not

B Only the dataflow updates, reports using it get updated automatically

C Nothing happens

D You must refresh each report manually

Refreshing a dataflow updates its data, and reports using that dataflow get the updated data automatically.

Explain what a dataflow is and why it is useful in Power BI.

Think about how dataflows help manage data before building reports.

Describe the steps to create a dataflow in Power BI Service.

Focus on the main actions inside Power BI Service.