
Power BI
Quiz by Support - BusinessPromoted .com
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
20 questions
Show answers
- Q1Which DAX function is used to calculate the cumulative total in Power BI?RUNNINGTOTALSUMCUMULATIVESUMTOTALYTD120s
- Q2In Power BI, what is the primary purpose of the 'Edit Interactions' feature?To modify data source settingsTo create new calculated columnsTo export data to ExcelTo control how visuals interact with each other120s
- Q3When would you use the 'ALLEXCEPT' DAX function?To remove all filters from a tableTo keep all filters in a tableTo remove filters from all columns in a table except specified onesTo apply filters to specific columns120s
- Q4What is the main use of the 'UserPrincipalName' function in Power BI?To get the department of the userTo get the role of the userTo get the user identity for dynamic securityTo get the last login time of the user120s
- Q5In Power BI, how can you optimize performance when dealing with large datasets?Increase the number of data importsLoad data more frequentlyUse more visuals on the report pageUse aggregations and reduce the number of visuals on the report page120s
- Q6How can you create a dynamic measure that changes based on slicer selection?Using conditional formattingUsing a calculated columnUsing a disconnected table and SWITCH functionUsing a filter condition120s
- Q7Which feature in Power BI allows you to drill through to a detailed report from a summary report?DrillthroughPage NavigationCross-ReportHierarchy120s
- Q8What is the main advantage of using DirectQuery mode over Import mode?Live connection to data, no data is stored in Power BIData is stored in Power BI for faster performanceRequires less storage in Power BIAllows for better compression of data120s
- Q9Which Power BI component would you use to share reports with other users within an organization?DashboardsReportsWorkspacesApps120s
- Q10How can you perform a many-to-many relationship in Power BI?By creating multiple relationshipsBy using direct queryBy using a bridge tableBy creating a calculated column120s
- Q11What is the purpose of using 'CALCULATE' function in DAX?To summarize dataTo join two tablesTo modify the filter context of a measureTo create a new table120s
- Q12In Power BI, what is the 'What If' parameter used for?To apply data validation rulesTo perform sensitivity analysisTo validate data entriesTo create what-if scenarios120s
- Q13How do you implement row-level security (RLS) in Power BI?Using bookmarksDefine roles and apply them to user groupsUsing R scriptsUsing gateways120s
- Q14What is the use of 'Bookmarks' in Power BI?To create multiple versions of a reportTo create a report templateTo capture the current state of a report pageTo manage report page layouts120s
- Q15How can you schedule data refreshes in Power BI Service?Using the dataset refresh settings in Power BI ServiceUsing Azure Data FactoryUsing Excel schedulerUsing Power BI Desktop120s