Creating and Sharing Reports

1. Can you explain the process of creating a report in Power BI?

Creating a report in Power BI follows a standard workflow that spans data preparation, modeling, and visual design:

1. Connect to data (Get Data) Open Power BI Desktop and click Get Data in the Home ribbon. Select from hundreds of connectors — databases, files, cloud services, Microsoft Fabric lakehouses, and more. For Fabric workloads, you can connect directly to a lakehouse SQL endpoint or a Fabric warehouse.

2. Transform data in Power Query After connecting, the Power Query Editor opens (or you can select "Transform Data" to open it). Apply transformation steps: filter rows, remove unnecessary columns, rename headers, change data types, merge or append queries, and handle null values. Every step is recorded as M code and replayed on refresh.

3. Define the semantic model In the Model view, create relationships between tables (using drag-and-drop or the Manage Relationships dialog). Define calculated columns and measures in DAX. Set table and column properties (hide technical columns from report view, set format strings, define synonyms for Q&A). In Fabric, you can also connect to a shared semantic model instead of building your own.

4. Build report visuals Switch to the Report view. Drag fields from the Data pane onto the canvas, or select a visual type first and then assign fields to its buckets (Axis, Values, Legend, etc.). Add multiple pages. Use slicers, filters (visual-level, page-level, report-level), and bookmarks to create interactive navigation.

5. Apply formatting and themes Use the Format pane to style visuals. Apply a report theme (JSON or built-in) for consistent branding. Add text boxes, images, shapes, and buttons for polish and navigation.

6. Use Copilot (optional) Copilot in Desktop can suggest and generate report pages or write DAX measures from natural-language descriptions, speeding up both authoring and measure creation.

7. Publish to the Service Click Publish in the Home ribbon, choose a workspace, and the report and semantic model are uploaded to the Power BI Service for sharing and scheduled refresh.

↑ Back to top

Follow-up 1

What are the different data sources you can use in Power BI?

Power BI supports a wide range of data sources, including:

Excel files
CSV files
SQL databases (e.g., Microsoft SQL Server, MySQL, Oracle)
Online services (e.g., SharePoint, Dynamics 365, Salesforce)
Web sources (e.g., HTML tables, JSON files)
Azure services (e.g., Azure SQL Database, Azure Data Lake Storage)
Big data sources (e.g., Hadoop, Spark)
On-premises data gateways for connecting to on-premises data sources.

You can also use Power Query to connect to custom data sources or perform data transformations before loading the data into Power BI.

Follow-up 2

What are the different types of visuals you can use in a Power BI report?

Power BI offers a wide range of visualizations to present your data effectively. Some of the commonly used visuals include:

Bar chart
Column chart
Line chart
Pie chart
Donut chart
Area chart
Scatter chart
Map
Table
Matrix
Card
Gauge
KPI
Slicer

These visuals can be customized with various formatting options, colors, and interactive features to enhance the user experience.

Follow-up 3

How can you customize the appearance of a report in Power BI?

To customize the appearance of a report in Power BI, you can:

Change the theme: Power BI provides built-in themes and allows you to create custom themes to change the overall look and feel of the report.
Format visuals: You can customize the colors, fonts, backgrounds, borders, and other visual properties of individual visuals.
Apply conditional formatting: You can highlight data based on certain conditions using conditional formatting options.
Add images and logos: You can insert images, logos, or icons to personalize the report.
Use custom visuals: Power BI supports custom visuals created by the community, which can be downloaded and added to your report.

These customization options help you create visually appealing and engaging reports.

Follow-up 4

How can you add filters to a report in Power BI?

In Power BI, you can add filters to a report in the following ways:

Visual-level filters: You can apply filters to individual visuals to focus on specific data points.
Page-level filters: You can apply filters to an entire page to control the data displayed in all visuals on that page.
Report-level filters: You can apply filters to the entire report to control the data displayed in all pages and visuals.
Drillthrough filters: You can define drillthrough filters to allow users to navigate from one visual to another based on specific data points.
Cross-filtering: Power BI automatically applies cross-filtering between related visuals, allowing you to filter data by selecting data points in one visual.

These filtering options help you analyze and explore your data in different ways.

2. How can you share a report in Power BI?

Power BI provides several methods to share a report, each suited to different audiences and governance requirements:

1. Share directly from the Service Open the report in the Power BI Service and click the Share button. Enter email addresses or security group names to grant access. You can control whether recipients can reshare the report or build new content from the underlying semantic model. Recipients need a Power BI Pro or PPU license, or the content must reside in a Premium or Fabric capacity workspace.

2. Power BI Apps Package a workspace's reports and dashboards into a Power BI App and publish it to an audience. Apps give consumers a clean, curated experience separate from the workspace used for development. Audience segmentation allows different user groups to see different subsets of the app's content.

3. Embed in Microsoft Teams or SharePoint Add a report as a tab in a Teams channel or embed it in a SharePoint Online page using the Power BI web part. This is useful when the audience already lives in Teams or SharePoint and should not need to navigate to the Power BI portal.

4. Publish to web (public embedding) In the Service, select File > Embed report > Publish to web. This generates an iframe embed code and a shareable URL accessible without authentication. Use only for non-sensitive, publicly appropriate content.

5. Embed in a custom application (Power BI Embedded) Developers can use the Power BI REST APIs and client SDKs to embed reports in internal portals or ISV products. End users in this scenario do not need individual Power BI licenses; access is governed by the application's own authentication and an Azure capacity.

6. Export options Reports can be exported to PDF or PowerPoint for one-time distribution. Individual visuals can be exported to CSV or Excel. Paginated reports (Premium/PPU) support high-fidelity exports for pixel-perfect documents.

7. Semantic model sharing (Build permission) Granting Build permission on a semantic model lets other report authors connect to it from Power BI Desktop and create their own reports — without being able to edit the original report.

↑ Back to top

Follow-up 1

What are the different ways to share a report in Power BI?

There are several ways to share a report in Power BI:

Share via email: You can send an email invitation to specific recipients, allowing them to access the report.
Publish to web: You can publish a report to the web and generate an embed code. This allows you to share the report on a website or blog.
Share with specific users or groups: You can share a report with specific users or groups within your organization, giving them access to view and interact with the report.
Share with everyone in your organization: You can share a report with everyone in your organization, making it accessible to all users with a Power BI account.

Follow-up 2

What permissions can you set when sharing a report in Power BI?

When sharing a report in Power BI, you can set the following permissions:

View: Users with view permission can only view the report and its visualizations. They cannot make any changes to the report.
Edit: Users with edit permission can view and edit the report. They can make changes to the report's visualizations, filters, and other settings.
Share: Users with share permission can share the report with others. They can send email invitations, publish the report to the web, and share it with specific users or groups.
Full control: Users with full control permission have complete control over the report. They can view, edit, share, and delete the report.

Follow-up 3

Can you share a report with someone who doesn't have a Power BI account?

No, you cannot share a report with someone who doesn't have a Power BI account. In order to access a shared report, the recipient must have a Power BI account. They can sign up for a free Power BI account or use an existing account to access the shared report.

Follow-up 4

What happens when you share a report with a user who has a Power BI free license?

When you share a report with a user who has a Power BI free license, they will be able to view and interact with the report, but they will have limited capabilities compared to users with a Power BI Pro license. Users with a free license can view and filter the report's visualizations, but they cannot perform certain actions such as exporting data, creating new visualizations, or sharing the report with others.

3. What is the difference between a report and a dashboard in Power BI?

Reports and dashboards are distinct artifacts in Power BI with different purposes, and interviewers commonly probe whether candidates understand the difference.

Report

A multi-page canvas created in Power BI Desktop (or the Service's report editor).
Each page can contain many visuals: charts, tables, maps, slicers, cards, AI visuals, etc.
Designed for detailed, interactive analysis — users can apply filters, drill through to detail pages, and cross-filter visuals by clicking on data points.
Visuals in a report are bound directly to a semantic model and recalculate dynamically as filters change.
Report pages can have page-level filters, visual-level filters, and report-level filters.
Reports are authored objects that can span complex multi-page narratives.

Dashboard

A single-page canvas created only in the Power BI Service (not Desktop).
Made up of tiles pinned from reports, Q&A, SSRS reports, or streaming datasets.
Designed for high-level monitoring — a single view of the most important KPIs across potentially multiple reports and semantic models.
Tiles on a dashboard are static snapshots that update when the underlying semantic model refreshes; clicking a tile navigates to the source report for deeper exploration.
Supports data alerts on numeric tiles (e.g., notify when a value exceeds a threshold).
Supports real-time streaming tiles for live operational data.
Does not support the same level of cross-filtering as reports — interactivity is limited.

Summary: use a report for detailed, multi-visual, interactive analysis; use a dashboard as a single-screen monitoring surface that links out to reports. In Microsoft Fabric environments, scorecards (goals/metrics) are a third artifact for tracking KPIs against targets.

↑ Back to top

Follow-up 1

Can you convert a report into a dashboard in Power BI?

Yes, you can convert a report into a dashboard in Power BI. To do this, you can pin visualizations from the report to a new or existing dashboard. Pinned visualizations retain their interactivity and can be resized, rearranged, and customized within the dashboard. This allows you to create a personalized dashboard using the visualizations from the report.

Follow-up 2

What are the limitations of a dashboard compared to a report in Power BI?

While dashboards in Power BI provide a quick and concise view of data, they have certain limitations compared to reports. Some of the limitations include:

Dashboards are limited to a single page, whereas reports can have multiple pages.
Dashboards have limited interactivity and filtering options compared to reports.
Dashboards cannot contain all types of visualizations available in reports.
Dashboards cannot have complex calculations or custom visuals like reports.

Despite these limitations, dashboards are still useful for presenting key metrics and summaries in a visually appealing and interactive manner.

Follow-up 3

How can you share a dashboard in Power BI?

To share a dashboard in Power BI, you can use the 'Share' feature. This allows you to give access to specific individuals or groups within your organization. You can share a dashboard by:

Opening the dashboard you want to share.
Clicking on the 'Share' button in the top-right corner.
Entering the email addresses or names of the people you want to share the dashboard with.
Choosing the access level (view or edit) for each person.
Adding an optional message.
Clicking on the 'Share' button to send the invitation.

Once shared, the recipients will be able to view or edit the dashboard based on the access level you have granted them.

Follow-up 4

Can you customize a dashboard in Power BI?

Yes, you can customize a dashboard in Power BI to suit your needs. Some of the customization options include:

Adding or removing visualizations: You can pin or unpin visualizations from the report to the dashboard.
Rearranging visualizations: You can drag and drop visualizations to rearrange their position on the dashboard.
Resizing visualizations: You can resize visualizations to make them larger or smaller.
Applying filters: You can apply filters to the visualizations on the dashboard to focus on specific data.
Adding text boxes or images: You can add text boxes or images to provide additional context or branding.

These customization options allow you to create a personalized and visually appealing dashboard in Power BI.

4. What is the role of Power BI Desktop in creating and sharing reports?

Power BI Desktop is the primary authoring tool in the Power BI ecosystem. It serves as the environment where data analysts, BI developers, and report authors build everything before it reaches end users.

Role in creating reports:

Data connectivity — Desktop includes the Get Data experience with hundreds of source connectors: relational databases, flat files, cloud APIs, Microsoft Fabric lakehouses and warehouses, SAP, Salesforce, and more.
Data transformation — the embedded Power Query Editor lets authors shape and clean data using a graphical interface backed by M code, with all steps recorded and replayed on refresh.
Semantic model authoring — the Model view is where authors define table relationships, create DAX calculated columns and measures, set up hierarchies, hide technical fields, and configure Row-Level Security roles. The semantic model is the reusable data layer that reports are built on.
DAX query view — a newer dedicated view in Desktop for writing DAX queries to test measure logic and explore model results without building a visual.
Report design — the Report canvas supports dozens of visual types, bookmarks, page navigation, tooltips, mobile layouts, and conditional formatting. Copilot in Desktop (where enabled) can generate report pages and draft DAX measures from natural language.
TMDL source control — saving as a .pbip project (instead of .pbix) stores the semantic model as TMDL files — human-readable YAML-like text — enabling meaningful Git diffs and branch-based development workflows with Azure DevOps or GitHub.

Role in sharing reports:

Desktop itself does not share reports with end users — that happens in the Power BI Service. The Desktop-to-Service workflow is: author in Desktop, Publish to a Service workspace, then share via the Service (direct share, app, Teams embed, etc.). Desktop is a local tool; the cloud Service is the distribution platform.

↑ Back to top

Follow-up 1

What are the advantages of using Power BI Desktop over Power BI Service for creating reports?

Some advantages of using Power BI Desktop over Power BI Service for creating reports are:

Power BI Desktop provides more advanced data modeling capabilities, allowing users to create complex relationships between tables and define calculated columns and measures.
Power BI Desktop allows users to perform advanced data transformations and data shaping operations using the Power Query Editor.
Power BI Desktop provides more flexibility in report design, allowing users to customize the visualizations and layout of the report.
Power BI Desktop can be used offline, allowing users to work on reports without an internet connection.

However, it's important to note that Power BI Desktop is primarily a development tool, and reports created in Power BI Desktop need to be published to the Power BI Service for sharing and collaboration.

Follow-up 2

Can you share a report directly from Power BI Desktop?

No, you cannot share a report directly from Power BI Desktop. Power BI Desktop is primarily a development tool used for creating reports. To share a report, you need to publish it to the Power BI Service. Once the report is published, you can share it with others by providing them with the appropriate access permissions.

Follow-up 3

What are the limitations of Power BI Desktop compared to Power BI Service?

Some limitations of Power BI Desktop compared to Power BI Service are:

Power BI Desktop does not provide real-time data refresh capabilities. To have real-time data in your reports, you need to use Power BI Service.
Power BI Desktop does not support automatic data refresh. To keep your reports up to date, you need to manually refresh the data in Power BI Desktop.
Power BI Desktop does not provide collaboration features like sharing and commenting on reports. These features are available in Power BI Service.
Power BI Desktop does not provide web-based access to reports. To view and interact with reports, you need to use Power BI Service or embed the reports in other applications.

It's important to note that Power BI Desktop and Power BI Service complement each other, and both have their own strengths and use cases.

Follow-up 4

Can you create a dashboard in Power BI Desktop?

No, you cannot create a dashboard directly in Power BI Desktop. Power BI Desktop is primarily used for creating reports and visualizations. However, once you have created the reports in Power BI Desktop, you can publish them to the Power BI Service and then create a dashboard using those reports. In Power BI Service, you can pin visualizations from different reports to a dashboard, arrange them, and add additional elements like images and text boxes to create a customized dashboard.

5. How can you schedule a report to refresh in Power BI?

Scheduled refresh is configured in the Power BI Service, not in Desktop. The Desktop publish step uploads the semantic model; refresh scheduling is done on that published semantic model in the cloud.

Steps to schedule a refresh:

Publish the report from Power BI Desktop to the Power BI Service.
Configure data source credentials — in the Service, navigate to the workspace, find the semantic model, click the three-dot menu and select Settings. Under Data source credentials, authenticate each data source. Without valid credentials the refresh will fail.
Set up a gateway (if needed) — if the data source is on-premises or inside a private network, associate the semantic model with an on-premises data gateway or VNet data gateway data source connection under the Gateway and cloud connections section in Settings.
Configure the refresh schedule — in the semantic model Settings, expand Scheduled refresh and toggle it on. Choose:
- Frequency: Daily or Weekly
- Time zone
- Up to 8 refresh times per day for Pro/PPU workspaces, or up to 48 times per day for Premium/Fabric capacity workspaces.
Enable refresh failure notifications — optionally configure email alerts to the semantic model owner or other contacts when a refresh fails.

Additional refresh options to know:

Incremental refresh — for large semantic models, define a refresh policy that only loads new or updated rows (e.g., the last 3 days) while retaining years of historical data in older partitions. Requires Premium or PPU.
On-demand refresh — click the refresh icon on the semantic model in the Service to trigger an immediate refresh outside the schedule.
Enhanced refresh via REST API — the Power BI REST API supports triggering, monitoring, and canceling refreshes programmatically, commonly used in CI/CD pipelines or orchestration tools like Azure Data Factory or Fabric Data Pipelines.
DirectQuery and DirectLake models — these do not require scheduled refresh because queries hit the source live (DirectQuery) or read current Delta files (DirectLake).

↑ Back to top

Follow-up 1

What are the different options for scheduling a report refresh in Power BI?

In Power BI, there are different options for scheduling a report refresh:

Manual Refresh: You can manually refresh the report data by clicking on the 'Refresh' button in the Power BI service or Power BI Desktop.
Scheduled Refresh: You can schedule a report to refresh at specific intervals, such as daily, weekly, or monthly.
DirectQuery: If your report is using DirectQuery mode, the data is always up to date as it is directly queried from the data source.

Note: The availability of these options may vary depending on your Power BI subscription.

Follow-up 2

What happens when a scheduled report refresh fails in Power BI?

When a scheduled report refresh fails in Power BI, the following actions can be taken:

Email notification: You can configure Power BI to send an email notification when a refresh fails. This can be done in the 'Schedule Refresh' dialog box by enabling the 'Notify me when this refresh fails' option.
Error details: You can view the error details by clicking on the 'Refresh history' link in the 'Schedule Refresh' dialog box. This will show you the refresh history and any error messages associated with failed refreshes.
Troubleshooting: You can troubleshoot the issue by checking the data source connection, credentials, and any other dependencies that might be causing the refresh failure.

Follow-up 3

Can you schedule a report to refresh more frequently in Power BI Pro than in Power BI Free?

Yes, you can schedule a report to refresh more frequently in Power BI Pro than in Power BI Free. Power BI Pro allows you to schedule refreshes as frequently as every 30 minutes, while Power BI Free only allows for daily refreshes. The ability to schedule more frequent refreshes is one of the benefits of having a Power BI Pro subscription.

Follow-up 4

What is the maximum frequency for a report refresh in Power BI?

The maximum frequency for a report refresh in Power BI is every 30 minutes. This frequency is available for Power BI Pro users. Power BI Free users can only schedule daily refreshes. It's important to note that the availability of this feature may vary depending on your Power BI subscription.