MCQs on Power BI Service Basics | Power BI
This article presents 30 multiple-choice questions (MCQs) on Power BI Service basics, including publishing reports, creating dashboards, and sharing reports and dashboards. These questions are designed to assess your proficiency in using Power BI for data visualization, reporting, and collaboration in a business environment.
MCQs on Power BI Service Basics
Publishing Reports to Power BI Service
- Which of the following is required to publish a report to Power BI Service?
- A) Power BI Desktop
- B) Power BI Mobile
- C) Excel
- D) SQL Server Management Studio
- When you publish a report from Power BI Desktop to Power BI Service, which format does the report take?
- A) Excel file
- B) Power BI Desktop file (.pbix)
- C) Web page
- D) CSV file
- Which of these actions can you perform directly from Power BI Service after publishing a report?
- A) Modify the report layout
- B) Share the report
- C) Connect to new data sources
- D) Edit the data model
- How do you publish a Power BI report from Power BI Desktop to Power BI Service?
- A) Use the “Save As” option
- B) Click “Publish” on the Home tab
- C) Click “Upload” in Power BI Service
- D) Use the “Export” option
- Which of the following can be shared after publishing to Power BI Service?
- A) Power BI files (.pbix)
- B) Reports and dashboards
- C) Only dashboards
- D) Only data models
- What happens to the data when a report is published to Power BI Service?
- A) The data is permanently uploaded to Power BI Service
- B) The data is retained as a live connection to the data source
- C) The data is stored locally on the user’s device
- D) Data cannot be accessed after publishing
- Which of the following is the correct step to publish a Power BI report?
- A) Open the report, then select “Publish” from the File menu
- B) Open the report in Power BI Service and click “Publish”
- C) Open the report, then select “Save As” and choose Power BI Service
- D) Open the report, then click “Export to Power BI Service”
- What should you do to ensure a report is accessible to other users after publishing to Power BI Service?
- A) Share the report or dashboard link
- B) Move the report to a public folder
- C) Send the Power BI Desktop file to users
- D) Save the report in Excel format
- How can you automate data refresh for a report published to Power BI Service?
- A) Set up data refresh in Power BI Desktop
- B) Configure refresh schedules in Power BI Service
- C) Refresh manually every time you access the report
- D) Data refresh is not possible after publishing
Creating Dashboards from Reports
- What is a Power BI dashboard?
- A) A collection of reports
- B) A single report with charts and tables
- C) A visualization of live data
- D) A collection of visuals pinned from reports
- Can you pin individual visuals from a report to create a dashboard in Power BI Service?
- A) No, you cannot pin visuals to a dashboard
- B) Yes, individual visuals can be pinned to a dashboard
- C) Only entire reports can be pinned to a dashboard
- D) Visuals can only be pinned from Power BI Desktop
- Which action is performed to create a dashboard in Power BI Service?
- A) Click “New Dashboard” and then select visuals
- B) Import data from Excel
- C) Pin visuals from existing reports
- D) Import a new report from Power BI Desktop
- In Power BI Service, how do you add a tile to a dashboard?
- A) Click “Add Tile” and select data from Excel
- B) Pin a visual from a report to the dashboard
- C) Upload a file and generate a visual
- D) Create a report and save it as a dashboard
- How can you modify a dashboard once it is created in Power BI Service?
- A) Modify the report directly in Power BI Desktop
- B) Modify the dashboard directly by editing the pinned visuals
- C) Only administrators can modify dashboards
- D) Dashboards cannot be modified after creation
- How can you rearrange tiles on a dashboard in Power BI Service?
- A) By dragging and dropping the tiles
- B) By opening the report and editing the layout
- C) By changing the tile properties in Power BI Desktop
- D) Dashboards do not allow tile rearrangement
- Can you create a dashboard without any underlying reports in Power BI Service?
- A) No, dashboards require reports to be created
- B) Yes, dashboards can be created from data files only
- C) Yes, you can manually add and design tiles
- D) Dashboards cannot be created in Power BI Service
- Which of the following is a valid way to customize a dashboard tile?
- A) Change the title and layout
- B) Edit the underlying report
- C) Pin additional visuals to the same tile
- D) Export the tile to Power BI Desktop
- What happens when you click on a tile in a Power BI dashboard?
- A) It opens the underlying report or data
- B) It displays additional dashboard options
- C) It generates a new report automatically
- D) It redirects to an external data source
- How can you remove a tile from a dashboard in Power BI Service?
- A) Right-click on the tile and select “Remove”
- B) Delete the report it is linked to
- C) Open the report and delete the visual
- D) Tiles cannot be removed from dashboards
- Can you pin visuals from different reports to the same dashboard in Power BI Service?
- A) No, visuals from different reports cannot be combined
- B) Yes, visuals from different reports can be pinned to the same dashboard
- C) Only visuals from the same report can be pinned
- D) Dashboards only allow text and not visuals
Sharing Reports and Dashboards
- Which feature in Power BI allows you to share reports with others?
- A) Publish to Web
- B) Share via email
- C) Share button in Power BI Service
- D) Export to PDF
- How can you share a report with others in Power BI Service?
- A) By sending them a link to the report
- B) By publishing the report to the web
- C) By exporting the report as an image
- D) By creating a Power BI workspace and adding users
- Which of the following is a limitation when sharing Power BI reports?
- A) You can only share reports with users in the same organization
- B) Only administrators can share reports
- C) Reports cannot be shared with external users
- D) Reports cannot be shared at all
- In Power BI Service, what is required to share a report with external users?
- A) A Power BI Pro license for both sender and recipient
- B) Only the sender needs a Power BI Pro license
- C) Only the recipient needs a Power BI Pro license
- D) No license is required
- What does the “Publish to Web” option do in Power BI Service?
- A) It makes the report available to everyone on the internet
- B) It sends the report as an email attachment
- C) It creates a live link for report viewing
- D) It shares the report with users within your organization
- Can you restrict access to a shared Power BI report?
- A) Yes, by setting permissions on the report or workspace
- B) No, once a report is shared, it is accessible to everyone
- C) Yes, by exporting the report to PDF
- D) No, access cannot be restricted once shared
- Which of the following is necessary to allow others to interact with a Power BI report you shared?
- A) Power BI Pro licenses for both the sender and recipient
- B) Allowing the recipient to download the report
- C) Giving the recipient permissions to edit the report
- D) The report must be published to the web
- Can you schedule an automatic report refresh in Power BI Service for shared reports?
- A) Yes, using the data refresh feature
- B) No, automatic refresh is only available for dashboards
- C) Yes, but only for reports created in Power BI Desktop
- D) No, data refresh must be done manually
- How can you manage permissions for shared Power BI reports?
- A) By using workspaces and managing access rights
- B) By editing the report directly
- C) By sending an email to the recipients
- D) Permissions cannot be managed once shared
- Which of the following is true about sharing dashboards in Power BI Service?
- A) Dashboards can be shared with specific users or groups
- B) Dashboards cannot be shared with others
- C) Dashboards can only be shared by admins
- D) Dashboards can only be shared within the organization
Answer Key
| Qno | Answer |
|---|---|
| 1 | A) Power BI Desktop |
| 2 | B) Power BI Desktop file (.pbix) |
| 3 | B) Share the report |
| 4 | B) Click “Publish” on the Home tab |
| 5 | B) Reports and dashboards |
| 6 | B) The data is retained as a live connection to the data source |
| 7 | A) Open the report, then select “Publish” from the File menu |
| 8 | A) Share the report or dashboard link |
| 9 | B) Configure refresh schedules in Power BI Service |
| 10 | D) A collection of visuals pinned from reports |
| 11 | B) Yes, individual visuals can be pinned to a dashboard |
| 12 | C) Pin visuals from existing reports |
| 13 | B) Pin a visual from a report to the dashboard |
| 14 | B) Modify the dashboard directly by editing the pinned visuals |
| 15 | A) By dragging and dropping the tiles |
| 16 | A) No, dashboards require reports to be created |
| 17 | A) Change the title and layout |
| 18 | A) It opens the underlying report or data |
| 19 | A) Right-click on the tile and select “Remove” |
| 20 | B) Yes, visuals from different reports can be pinned to the same dashboard |
| 21 | C) Share button in Power BI Service |
| 22 | A) By sending them a link to the report |
| 23 | A) You can only share reports with users in the same organization |
| 24 | A) A Power BI Pro license for both sender and recipient |
| 25 | A) It makes the report available to everyone on the internet |
| 26 | A) Yes, by setting permissions on the report or workspace |
| 27 | A) Power BI Pro licenses for both the sender and recipient |
| 28 | A) Yes, using the data refresh feature |
| 29 | A) By using workspaces and managing access rights |
| 30 | A) Dashboards can be shared with specific users or groups |