70+ power bi MCQ and answers with explanation

Are you preparing for a Power BI certification exam or looking to brush up on your knowledge of this powerful business intelligence tool? Look no further! In this article, we’ve compiled a list of 70+ power BI MCQs along with detailed explanations of the answers.

Power BI is a suite of business analytics tools that allow users to analyze data and share insights. It is used by businesses of all sizes to visualize and analyse data in order to make informed decisions.

So, are you ready to test your knowledge of Power BI? Let’s get started with these Power BI MCQs!

Q1. What symbol would you use for multiplication in Power BI in a DAX formula?

1. +
2. –
3. /
4. *

Answer: (d) *

The symbol used for multiplication in the Power BI DAX formula is the asterisk (*). It is used between the factors to be multiplied. Using any other symbol like +, -, or / for multiplication will result in errors or unexpected results.

Q2. Which of the following is a data visualization feature in Power BI?

1. Charts
2. Word processing
3. Video editing
4. Animation

Answer: (a) Charts

To assist users in visualizing their data, Power BI offers a broad range of charts and graphs, such as bar charts, line charts, pie charts, and scatter plots.

Q3. What is Power BI?

A. business analytics tool
b.  database management system
c. project management software
d.  graphic design tool

Answer: (a) A business analytics tool

Developed by Microsoft, Power BI is a business analytics tool that enables users to connect, analyze, and visualize data from diverse sources, ranging from cloud services to on-premises databases.

Q4. Which of the following is a data transformation feature in Power BI?

1. Data modeling
2. Data visualization
3. Data exploration
4. Data cleansing

Answer: (d) Data cleansing

Data cleansing is a data transformation feature in Power BI that allows users to clean, transform, and reshape data to prepare it for analysis.

Q5. Which programming language is used to create custom visuals in Power BI?

1. Python
2. C#
3. Java
4. R

Answer: (d) R

R is a programming language used for statistical computing and graphics. It is one of the supported languages for creating custom visuals in Power BI.

Q6. Which of the following is a visualization option in Power BI?

1. Pivot table
2. Histogram
3. Bubble chart
4. All of the above

Answer: (d) All of the above

Power BI offers various visualization options, including pivot tables, histograms, and bubble charts, to help users analyze and interpret their data.

Q7. Functions that belong to the category of TEXT FUNCTION.

1. IF
2. DATE
3. CONCATENATE
4. COUNT

Answer: (c) CONCATENATE

CONCATENATE is a text function in Power BI that allows users to combine multiple strings of text into a single cell. The other options listed are not text functions; IF is a logical function, DATE is a date and time function, and COUNT is an aggregation function.

Q8. Which of the following is NOT a data source that can be used in Power BI?

1. Excel spreadsheets
2. JSON files
3. Oracle databases
4. Adobe Photoshop files

Answer: (d) Adobe Photoshop files

Power BI can connect to various data sources, including Excel spreadsheets, JSON files, and Oracle databases, but it cannot connect to Adobe Photoshop files.

Q9. Which of the following is a way to filter data in Power BI?

1. Slicer
2. Scatter plot
3. Histogram
4. Line chart

Answer: (a) Slicer

A slicer is a way to filter data in Power BI. Slicers allow users to interactively filter data by selecting one or more values from a list.

Q10. Contains reference data such as descriptive attributes__________________

1. Fact table
2. Query table
3. Dimension table
4. Power BI table

Answer: (c) Dimension table

In a data warehousing context, a dimension table comprises a key column (or columns) that serves as a unique identifier, along with descriptive columns that provide context and additional information. On the other hand, fact tables store observations or events, which could be sales orders, stock balances, exchange rates, temperatures, or any other measurable quantity.

Q11. Which of the following statements is true about shaping data with Power BI Desktop_____________

1. When shaping or transforming data in Power BI Desktop, the source data remains unchanged
2. The order in which you shape or transform data doesn’t matter, it all comes out the same
3. When shaping or transforming data in Power BI Desktop, the source data is also shaped and transformed
4. None of these

Answer: (c) When shaping or transforming data in Power BI Desktop, the source data remains unchanged

When shaping or transforming data with Power BI Desktop, the original data is not altered in any way at any time during the process. Any changes made during the shaping and transforming process are applied to a copy of the original data, leaving the source data unchanged.

Q12. What is a dashboard in Power BI?

1. A data source that provides access to raw data for analysis
2. A collaboration tool that allows users to share and work on data together
3. A visual representation of data that provides an at-a-glance view of key metrics
4. A report that contains detailed information about a specific topic or area

Answer: (c) A visual representation of data that provides an at-a-glance view of key metrics

A dashboard in Power BI is a visual representation of data that provides an at-a-glance view of key metrics and performance indicators for a business or organization.

Q13. What is a measure in Power BI?

1. A connection to a data source
2. A visualization option for displaying data
3. A calculation based on data in a dataset
4. A filter that restricts the amount of data displayed in a report

Answer: (c) A calculation based on data in a dataset

A measure in Power BI is a calculation based on data in a dataset. Measures can be used to perform calculations such as sums, averages, and percentages.

Q14. What is the purpose of Power Query in Power BI?

1. To create and manage data models
2. To analyze and visualize data
3. To import, transform, and combine data from various sources
4. To create custom visuals for data visualization

Answer: (c) To import, transform, and combine data from various sources

Power Query is a data transformation and cleaning tool in Power BI that allows users to import, transform, and combine data from various sources.

Q15. What is the purpose of Power View in Power BI?

1. To create and share reports and dashboards
2. To import and transform data from various sources
3. To analyze and visualize data
4. To create and manage data models

Answer: (c) To analyze and visualize data

Power View is a data visualization tool in Power BI that allows users to create interactive, visual reports and dashboards to analyze and visualize data.

Q16. What is the purpose of the Power BI service?

1. To create and manage data models
2. To import and transform data from various sources
3. To analyze and visualize data
4. To share reports and dashboards with other users

Answer: (d) To share reports and dashboards with other users

The Power BI service is a cloud-based platform that allows users to share reports and dashboards with other users. It also provides additional features such as collaboration, data exploration, and administration.

Q17. Which of the following is a way to share a report or dashboard in Power BI?

1. Publish to the Power BI service
2. Export to a PDF file
3. Share via email
4. All of the above

Answer: (a) Publish to the Power BI service

The recommended way to share a report or dashboard in Power BI is to publish it to the Power BI service. This allows other users to view and interact with the report or dashboard in a web browser.

Q18. What is the purpose of Power Pivot in Power BI?

1. To import and transform data from various sources
2. To create and manage data models
3. To analyze and visualize data
4. To share reports and dashboards with other users

Answer: (b) To create and manage data models

Power Pivot is a data modeling tool in Power BI that allows users to create and manage data models. It allows users to define relationships between tables and create calculated columns and measures.

Q19. Which of the following is a way to create a new measure in Power BI?

1. Using DAX formula language
2. Using SQL query language
3. Using Python programming language
4. Using JavaScript programming language

Answer: (a) Using DAX formula language

DAX (Data Analysis Expressions) is a formula language used to create measures and calculated columns in Power BI.

Q20. Which of the following is a way to create a calculated column in Power BI?

1. Using DAX formula language
2. Using SQL query language
3. Using Python programming language
4. Using JavaScript programming language

Answer: (a) Using DAX formula language

DAX (Data Analysis Expressions) is a formula language used to create calculated columns and measures in Power BI. Calculated columns can be used to add new columns to a table based on a DAX expression.

Q21. Which of the following is a way to connect to a data source in Power BI?

1. Using a web browser
2. Using a command-line interface
3. Using an API
4. All of the above

Answer: (a) Using a web browser

The most common way to connect to a data source in Power BI is to use a web browser. Power BI also provides other methods such as command-line interfaces and APIs for connecting to data sources.

Q22. What file format is used for Power BI files?

1. .xlsx
2. .pbi
3. .pbix
4. .xls

Answer: (c) .pbix

Power BI files are saved in the .pbix file format. These files are highly compressed and contain all the graphics and data needed for the Power BI report. The file extension for Power BI files is “.pbix” and it allows users to easily share and collaborate on their reports with others. The other file extensions listed in the options, such as .xlsx and .xls, are file formats used for Microsoft Excel spreadsheets and are not used for Power BI files.

Q23. Which of the following is a way to filter data in Power BI?

1. Using a slicer
2. Using a chart
3. Using a table
4. All of the above

Answer: (a) Using a slicer

Slicers are visual controls in Power BI that allow users to filter data in a report or dashboard. They can be used with charts, tables, and other visualizations.

Q24. What is the purpose of the Query Editor in Power BI?

1. To create and manage data models
2. To import and transform data from various sources
3. To analyze and visualize data
4. To share reports and dashboards with other users

Answer: (b) To import and transform data from various sources

The Query Editor in Power BI is a data transformation and cleaning tool that allows users to import, transform, and combine data from various sources.

Q25. What are the building blocks of Power BI?

1. Visual Studio, C#, and JSON files
2. Tiles, dashboards, databases, mobile devices
3. Visualizations, datasets, reports, dashboards, tiles
4. None of the above

Answer: (c) Visualizations, datasets, reports, dashboards, tiles

The major building blocks of Power BI are visualizations, datasets, reports, dashboards, and tiles. Visualizations are the individual charts, graphs, and other displays that make up a report. Datasets are the collections of data that Power BI uses to create visualizations. Finally, reports are collections of visualizations that are organized into pages.

Dashboards are high-level views of multiple reports and visualizations. Tiles are the individual components that make up a dashboard. These building blocks are organized into workspaces and created on capacities. The other options listed in the answer choices are not building blocks of Power BI.

Q26. Which of the following is a way to create a hierarchy in Power BI?

1. Using the Fields pane
2. Using the Filters pane
3. Using the Visualizations pane
4. Using the Pages pane

Answer: (a) Using the Fields pane

The Fields pane in Power BI allows users to create hierarchies by dragging and dropping fields onto each other. Hierarchies can be used to drill down into data and explore relationships between data points.

Q27. Which of the following is a way to share a report in Power BI?

1. Exporting to a PDF file
2. Publishing to the Power BI service
3. Sharing a link to the report
4. All of the above

Answer: (d) All of the above

Reports in Power BI can be shared in multiple ways, including exporting to a PDF file, publishing to the Power BI service, and sharing a link to the report.

Q28. Which of the following is a way to create a dashboard in Power BI?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using a mobile app
4. All of the above

Answer: (b) Using the Power BI service

Dashboards in Power BI can be created using the Power BI service. They allow users to view key metrics and performance indicators in a single, interactive view.

Q29. Where do you go to modify and transform data in Power BI?

1. Data Transformation
2. Data Editing
3. Question Editor
4. Data Modeling

Answer: (b) Data Editing

One should go to the Data Editing area to modify and transform data in Power BI. This can be accessed by going to the Query Editor and selecting the desired dataset on the left side. Once the dataset is selected, navigate to the cell that needs to be edited and right-click to bring up a menu.

From there, select the “Replace Values” option to modify the data. Data Transformation and Data Modeling are also important aspects of working with data in Power BI, but they refer to different stages of the data processing pipeline.

Q30. What is the purpose of the Power BI mobile app?

1. To create and share reports and dashboards
2. To analyze and visualize data
3. To view and interact with reports and dashboards on mobile devices
4. To create and manage data models

Answer: (c) To view and interact with reports and dashboards on mobile devices

The Power BI mobile app allows users to view and interact with reports and dashboards on mobile devices such as smartphones and tablets. It provides features such as touch-based navigation, drill-down, and offline access.

Q31. Creates the connection between Power BI cloud-based data and the data source located on-premises_______________

1. Report view
2. Power BI service
3. Gateway
4. Query editor

Answer: (c) Gateway

The Gateway is responsible for creating the connection between Power BI cloud-based data analysis technology and the data source on-premises. Gateway is an application that can be installed on any server in the local domain.

Q32. Which of the following is a way to create a custom visual in Power BI?

1. Using the Developer tools
2. Using the Visualizations pane
3. Using the Fields pane
4. Using the Format pane

Answer: (a) Using the Developer tools

Power BI provides developer tools for creating custom visuals using HTML, CSS, and JavaScript. Custom visuals can be used to create unique data visualizations and add additional functionality to Power BI reports and dashboards.

Q33. What is the purpose of the Q&A feature in Power BI?

1. To create and share reports and dashboards
2. To analyze and visualize data
3. To create and manage data models
4. To allow users to ask natural language questions and get answers from data

Answer: (d) To allow users to ask natural language questions and get answers from data

The Q&A feature in Power BI allows users to ask natural language questions about data and get answers in the form of visualizations and reports. It uses natural language processing and machine learning algorithms to understand user queries and generate results.

Q34. Which of the following is a way to create a report in Power BI?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using a mobile app
4. All of the above

Answer: (a) Using the Power BI desktop application

The Power BI desktop application is a Windows application that allows users to create and edit reports and dashboards. It provides advanced features for data modeling, data transformation, and data visualization.

Q35. What is the purpose of the Power BI API?

1. To analyze and visualize data
2. To allow integration with other applications and services
3. To create and share reports and dashboards
4. To create and manage data models

Answer: (b) To allow integration with other applications and services

The Power BI API allows developers to programmatically interact with Power BI to perform tasks such as embedding Power BI reports and dashboards in other applications, automating report generation and distribution, and managing Power BI content and resources.

Q36. Which of the following is a way to format a visual in Power BI?

1. Using the Visualizations pane
2. Using the Fields pane
3. Using the Format pane
4. Using the Developer tools

Answer: (c) Using the Format pane

The Format pane in Power BI allows users to format visuals in a report or dashboard. It provides options for changing colors, fonts, and other visual properties.

Q37. Which of the following is a way to perform data modeling in Power BI?

1. Using the Data view
2. Using the Visualizations pane
3. Using the Format pane
4. Using the Developer tools

Answer: (a) Using the Data view

The Data view in Power BI allows users to perform data modeling tasks such as creating relationships between tables, creating calculated columns, and applying filters to data.

Q38. Which of the following is a way to create a measure in Power BI?

1. Using the Data view
2. Using the Visualizations pane
3. Using the Format pane
4. Using the Developer tools

Answer: (a) Using the Data view

Measures in Power BI are created using the Data view. They are used to perform calculations on data, such as sums, averages, and percentages.

Q39. Which of the following is a way to embed a Power BI report in a website or application?

1. Using the Power BI web part in SharePoint
2. Using the Power BI JavaScript API
3. Using the Power BI mobile app
4. Using the Power BI Report Server

Answer: (b) Using the Power BI JavaScript API

The Power BI JavaScript API allows developers to embed Power BI reports and dashboards in other applications and web pages. It provides a set of JavaScript functions that can be used to interact with Power BI content.

Q40. What is the purpose of the Power BI paginated report?

1. To create interactive and visually appealing reports and dashboards
2. To create static and printable reports
3. To create ad-hoc reports and analysis
4. To create reports that can be embedded in other applications

Answer: (b) To create static and printable reports

Power BI paginated reports are designed to create static, printable reports that are optimized for printing or generating PDF documents. They are ideal for creating forms, invoices, and other types of structured documents.

Q41. Which data type is not supported in Power BI?

1. General
2. Decimal Number
3. Binary type
4. Double

Answer: (c) Binary type

Binary data type is not supported in the Power BI data model. Although the option for Binary type exists in the Data View and Report View menus, it is only there for legacy reasons. If you try to load binary columns to the Power BI model, you may encounter errors. The General, Decimal Number, and Double data types are all supported in Power BI and can be used to compose data.

Q42. Which of the following is a way to create a Power BI dashboard?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. All of the above

Answer: (b) Using the Power BI service

Power BI dashboards are created using the Power BI service. They allow users to create visualizations that provide a high-level overview of data from multiple sources.

Q43. Which of the following is a way to create a Power BI paginated report?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using SQL Server Reporting Services (SSRS)
4. All of the above

Answer: (c) Using SQL Server Reporting Services (SSRS)

Power BI paginated reports are created using SQL Server Reporting Services (SSRS), a reporting platform that is integrated with Power BI. Paginated reports can be published to the Power BI service and shared with users.

Q44. What is the purpose of the Power BI data gateway?

1. To create and manage data models in Power BI
2. To connect to on-premises data sources from the Power BI service
3. To create custom visuals for Power BI reports and dashboards
4. To manage user access to Power BI content

Answer: (b) To connect to on-premises data sources from the Power BI service

The Power BI data gateway is used to connect to on-premises data sources from the Power BI service. It allows users to securely access data that is located behind a firewall or on a private network.

Q45. Which of the following is a way to create a Power BI data gateway?

1. Using the Power BI mobile app
2. Using the Power BI gateway installer
3. Using the Power BI desktop application
4. Using the Power BI service

Answer: (b) Using the Power BI gateway installer

The Power BI gateway installer is used to create a Power BI data gateway. It can be downloaded from the Power BI service and installed on a computer or server that is connected to the on-premises data source.

Q46. Which of the following is a way to access Power BI content offline?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. None of the above

Answer: (c) Using the Power BI mobile app

The Power BI mobile app allows users to access Power BI content offline by downloading reports and dashboards to their mobile devices.

Q47. What is the purpose of the Power BI premium capacity?

1. To provide additional data modeling capabilities in Power BI
2. To manage user access to Power BI content
3. To increase the performance and scalability of Power BI reports and dashboards
4. To create custom visuals for Power BI reports and dashboards

Answer: (c) To increase the performance and scalability of Power BI reports and dashboards

The Power BI premium capacity is used to increase the performance and scalability of Power BI reports and dashboards. It provides additional processing power and memory, allowing users to work with larger datasets and more complex reports.

Q48. Which of the following is a way to create a Power BI premium capacity?

1. Using the Power BI desktop application
2. Using the Power BI mobile app
3. None of the above
4. Using the Power BI service

Answer: (d) Using the Power BI service

The Power BI service allows users to create a Power BI premium capacity. This can be done by purchasing a Power BI Premium license and then assigning the capacity to a workspace in the Power BI service.

Q49. What type of data is stored in a fact table in Power BI?

1. Query table
2. Dimension table
3. Power BI table
4. Fact table

Answer: (d) Fact table

A fact table is a central table in a star schema of a data warehouse. It contains transactional data or facts of a business process, such as sales, revenue, units sold, etc. Fact tables are linked to dimension tables through foreign keys and provide the context for the data stored in the dimension tables. In Power BI, a fact table consists of the measurements, metrics, or facts of a business process.

Q50. Which of the following is a way to create a Power BI Embedded solution?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. Using the Power BI Embedded SDK

Answer: (d) Using the Power BI Embedded SDK

The Power BI Embedded SDK is used to create a Power BI Embedded solution. It provides a set of APIs that can be used to embed Power BI content in other applications and web pages.

Q51. What is the purpose of Power BI Embedded?

1. To embed Power BI content in other applications
2. To provide additional data modeling capabilities in Power BI
3. To manage user access to Power BI content
4. To increase the performance and scalability of Power BI reports and dashboards

Answer: (a) To embed Power BI content in other applications

Power BI Embedded allows developers to embed Power BI reports and dashboards in other applications and web pages. It provides a set of APIs that can be used to interact with Power BI content.

Q52. Which of the following is a way to schedule the refresh of a Power BI dataset?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. None of the above

Answer: (b) Using the Power BI service

The Power BI service allows users to schedule the refresh of a Power BI dataset. This can be done by configuring a refresh schedule in the dataset settings.

Q53. Which of the following is a way to customize the appearance of a Power BI report?

1. Using custom themes
2. Using custom visuals
3. Using custom tooltips
4. All of the above

Answer: (d) All of the above

Power BI reports can be customized using custom themes, custom visuals, and custom tooltips. This allows users to create reports that match the branding and style of their organization.

Q54. What is the purpose of Power BI paginated reports?

1. To provide a high-level overview of data from multiple sources
2. To create interactive data visualizations
3. To create pixel-perfect, paginated reports for printing and PDF generation
4. To embed Power BI content in other applications

Answer: (c) To create pixel-perfect, paginated reports for printing and PDF generation

Power BI paginated reports are used to create pixel-perfect, paginated reports that are optimized for printing and PDF generation. They provide precise control over the layout and formatting of the report.

Q55. Which of the following is a way to monitor the performance of a Power BI report?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. None of the above

Answer: (b) Using the Power BI service

The Power BI service provides tools for monitoring the performance of a Power BI report. This includes metrics such as page load time, rendering time, and query duration.

Q56. How can row-level security be set up in Power BI?

1. Using DAX formulas
2. Using Power Query
3. Using Power Automate
4. None of the above

Answer: (a) Using DAX formulas

Row-level security is used to restrict access to specific rows of data in Power BI reports. It can be set up using DAX formulas in Power BI. DAX formulas are used to define filters on tables based on the user or group accessing the data.

Q57. What is the way to export data from a Power BI report?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. All of the above

Answer: (b) Using the Power BI service

Power BI reports can be exported to other formats such as Excel, CSV, or PDF using the Power BI service. Users can export data from specific visualizations by selecting the desired visualization, clicking the ellipsis button, and selecting “Export data”.

Q58. What is the common flow of activity in Power BI?

1. Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop
2. Create a report in Power BI mobile, share it to Power BI Desktop, view and interact in the Power BI service
3. Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile
4. Bring data into Power BI mobile, create a report, then share it to Power BI Desktop

Answer: (c) Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile

The common flow of activity in Power BI is to bring data into Power BI Desktop and create a report. Then publish it to the Power BI service, where you can create new visualisations or build dashboards. Finally, you can share your dashboards with others, especially people who are on-the-go.

Q59. How can a Power BI report be shared with others?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. All of the above

Answer: (d) All of the above

Power BI reports can be shared with others using the Power BI desktop application, the Power BI service, and the Power BI mobile app. Users can share reports with individuals, groups, or the public by setting up permissions and access levels.

Q60. What is the way to create a calculated table in Power BI?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. None of the above

Answer: (a) Using the Power BI desktop application

Calculated tables can be created in Power BI using the Power BI desktop application. Users can create a calculated table by defining it using DAX formulas based on the underlying data. Calculated tables are useful when there is a need to create a table that is not available in the data source.

Q61. What is the way to create a data model in Power BI?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. All of the above

Answer: (a) Using the Power BI desktop application

Data models in Power BI can be created using the Power BI desktop application. Users can import data from various sources and then use the Power Query Editor and DAX formulas to transform and model the data. The Power BI desktop application provides users with powerful modeling capabilities to create robust data models.

Q62. Which of the following is a way to add custom visuals to a Power BI report?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. None of the above

Answer: (a) Using the Power BI desktop application

Custom visuals can be added to a Power BI report by using the Power BI desktop application. Users can import custom visuals from the marketplace and then add them to the report canvas.

Q63. Which of the following is a way to create a drillthrough in Power BI?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. All of the above

Answer: (a) Using the Power BI desktop application

Explanation: Drillthroughs in Power BI can be created by using the Power BI desktop application. Users can select the desired visual and configure the drillthrough options in the Visualizations pane.

Q64. Which of the following is a way to create a paginated report in Power BI?

1. Using the Power BI desktop application
2. Using the Power BI service
3. Using the Power BI mobile app
4. None of the above

Answer: (d) None of the above

Paginated reports in Power BI are created by using the Power BI Report Builder application, which is a separate tool from the Power BI desktop application and the Power BI service.

Q65. Which of the following is a way to refresh data in a Power BI report?

1. Manually refreshing the report in the Power BI desktop application
2. Scheduling automatic refreshes in the Power BI service
3. Using Power Automate to trigger a refresh
4. All of the above

Answer: (d) All of the above

Data in a Power BI report can be refreshed manually in the Power BI desktop application, scheduled for automatic refreshes in the Power BI service, or triggered by a Power Automate flow.

Q66. What values would match the syntax LIKE “%apple” in Power BI?

1. Star apple
2. Banapple
3. Peach apple
4. All of the above

Answer: (d) All of the above

The % character in Power BI is a wildcard that can represent any number of characters before the specific letter or set of letters. So in this case, any value that ends with “apple” will be matched, including “star apple”, “banapple”, and “peach apple”.

Q67. Which of the following is a way to use natural language queries in Power BI?

1. Using the Q&A feature in the Power BI service
2. Using the Power BI mobile app
3. Using the Power BI desktop application
4. All of the above

Answer: (d) All of the above

Natural language queries can be used in Power BI through the Q&A feature in the Power BI service, the Power BI mobile app, and the Power BI desktop application. This allows users to ask questions in everyday language and get answers in the form of interactive visuals.

Q68. Calculate a result from an expression formula and the result can only be viewed in the visualization______________

1. Measures
2. Function
3. Calculated column
4. Filter

Answer: (a) Measures

Measures are used to calculate a result from an expression formula, and the result can only be viewed in the visualization. Measured values cannot be directly added to tables or charts.

Q69. A collection of software services, apps, and connectors to turn unrelated sources of data into coherent insights_________________

1. Power BI
2. Power Service
3. Query Editor
4. Visual Marketplace

Answer: (a) Power BI

Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights.

Q70. Which of the following illustrates a Many to One relationship?

1. Many banana trees planted in a garden
2. Many gardens having no banana trees
3. 1 banana tree having many bananas on the tree
4. Many banana trees planted in more than 1 garden

Answer: (a) Many banana trees planted in a garden

A Many-to-One relationship exists when many instances of one entity are associated with one instance of another entity. In the given options, “Many banana trees planted in a garden” shows a Many-to-One relationship.

CONCLUSION

In all, Power BI is a powerful business analytics service provided by Microsoft that allows users to create interactive visualizations and gain valuable insights from their data. These 70+ Power BI MCQs provide a comprehensive overview of the platform and cover a wide range of topics including data modeling, visualizations, DAX expressions, and more.

By understanding the answers and explanations provided for these questions, users can improve their Power BI skills and better utilize the platform to meet their business needs. Whether you are a beginner or an experienced Power BI user, these power BI MCQs are a valuable resource for enhancing your understanding of this popular tool.