Power BI Essential Training Questions
and Answers 100% Pass
How does Power BI connect to external data sources?
✔✔ Through data connectors that allow integration with databases, Excel files, online services,
and more.
What is the difference between Power BI Desktop and Power BI Service?
✔✔ Power BI Desktop is used to create reports and data models, while Power BI Service is for
sharing and collaborating on reports online.
Which visualization in Power BI is ideal for showing parts of a whole?
✔✔ Pie chart
What is the role of the "Data Model" in Power BI?
✔✔ The data model allows users to define relationships between different data tables and build
calculations.
What does "Power BI Gateway" do?
1
,✔✔ It allows for the secure transfer of on-premises data to the Power BI Service.
What is a measure in Power BI?
✔✔ A measure is a calculation used in data analysis, often involving aggregation such as sum,
average, or count.
How does Power BI handle relationships between tables?
✔✔ It uses primary and foreign keys to link tables together in a data model, enabling cross-table
analysis.
What is the function of the "Slicer" in Power BI?
✔✔ A slicer is used to filter data dynamically in reports, allowing users to view specific subsets
of data.
How can users refresh data in Power BI?
✔✔ Data can be refreshed manually or set to refresh automatically at scheduled intervals.
What is the "Drillthrough" feature in Power BI?
2
, ✔✔ Drillthrough allows users to right-click on data points and view detailed information in a
separate report page.
What does "DAX" stand for in Power BI?
✔✔ Data Analysis Expressions
What is the purpose of "Power BI Service"?
✔✔ Power BI Service is a cloud-based platform used to share, collaborate, and publish Power BI
reports and dashboards.
How does Power BI allow for real-time reporting?
✔✔ Power BI can connect to real-time data sources, allowing for live updates and dynamic
dashboards.
What is the difference between "Power Query" and "Power Pivot" in Power BI?
✔✔ Power Query is used to clean and transform data, while Power Pivot is used to create data
models and perform calculations.
What is the use of "Bookmarks" in Power BI?
3
and Answers 100% Pass
How does Power BI connect to external data sources?
✔✔ Through data connectors that allow integration with databases, Excel files, online services,
and more.
What is the difference between Power BI Desktop and Power BI Service?
✔✔ Power BI Desktop is used to create reports and data models, while Power BI Service is for
sharing and collaborating on reports online.
Which visualization in Power BI is ideal for showing parts of a whole?
✔✔ Pie chart
What is the role of the "Data Model" in Power BI?
✔✔ The data model allows users to define relationships between different data tables and build
calculations.
What does "Power BI Gateway" do?
1
,✔✔ It allows for the secure transfer of on-premises data to the Power BI Service.
What is a measure in Power BI?
✔✔ A measure is a calculation used in data analysis, often involving aggregation such as sum,
average, or count.
How does Power BI handle relationships between tables?
✔✔ It uses primary and foreign keys to link tables together in a data model, enabling cross-table
analysis.
What is the function of the "Slicer" in Power BI?
✔✔ A slicer is used to filter data dynamically in reports, allowing users to view specific subsets
of data.
How can users refresh data in Power BI?
✔✔ Data can be refreshed manually or set to refresh automatically at scheduled intervals.
What is the "Drillthrough" feature in Power BI?
2
, ✔✔ Drillthrough allows users to right-click on data points and view detailed information in a
separate report page.
What does "DAX" stand for in Power BI?
✔✔ Data Analysis Expressions
What is the purpose of "Power BI Service"?
✔✔ Power BI Service is a cloud-based platform used to share, collaborate, and publish Power BI
reports and dashboards.
How does Power BI allow for real-time reporting?
✔✔ Power BI can connect to real-time data sources, allowing for live updates and dynamic
dashboards.
What is the difference between "Power Query" and "Power Pivot" in Power BI?
✔✔ Power Query is used to clean and transform data, while Power Pivot is used to create data
models and perform calculations.
What is the use of "Bookmarks" in Power BI?
3
