How to Publish Dashboard in Power BI Service

You have built a beautiful Power BI report in Power BI Desktop — clean visuals, interactive slicers, well-structured data model. Now comes the most important step:

Getting it in front of the people who need it.

Publishing to Power BI Service is how you move your report from your local machine to the cloud where teammates, managers, and stakeholders can access it from any browser or mobile device, see automatically refreshed data, and interact with dashboards without needing Power BI Desktop installed.

In this guide, we will walk through the entire process of publishing to Power BI Service from your first publish to scheduling data refresh, creating dashboards, and sharing with your team.

What Is Power BI Service?

Power BI Service (app.powerbi.com) is the cloud-based platform where Power BI reports and dashboards are hosted, shared, and consumed.

Think of the relationship this way:

• Power BI Desktop — Where you build and design reports (local application)
• Power BI Service — Where you publish, share, and manage those reports (cloud platform)

Power BI Service adds capabilities that Desktop cannot provide on its own — cloud hosting, scheduled data refresh, team collaboration, sharing and permissions management, dashboards that combine visuals from multiple reports, and mobile access.

What You Need Before Publishing

Before publishing, make sure you have:

Power BI Desktop installed — Download free from microsoft.com/power-bi

A Power BI account — Sign in with a Microsoft work or school email. Free accounts have limited sharing. Power BI Pro ($10/user/month) enables full sharing and collaboration.

A completed report — A .pbix file with at least one page of visuals ready to publish

Internet connection — Publishing requires connection to the Power BI Service cloud

Step 1: Sign In to Power BI Desktop

Before you can publish, you must be signed into Power BI Desktop with your Microsoft account.

1. Open Power BI Desktop
2. Click Sign in in the top-right corner
3. Enter your Microsoft work or school email address
4. Complete the authentication process
5. Your name or email will appear in the top-right corner when signed in successfully

If you see a banner saying “Sign in to save and share your work” — click it to sign in before attempting to publish.

Step 2: Save Your Report

Always save your .pbix file before publishing. This ensures the version you publish matches your saved file.

File → Save (Ctrl + S)

Give your file a clear, descriptive name that stakeholders will recognize. For example “Q2 2024 Sales Performance Report” rather than “Report1” or “Final_v3”.

Step 3: Publish to Power BI Service

This is the core publishing step.

Option 1: From the Home Tab

1. Go to the Home tab in the Power BI Desktop ribbon
2. Click the Publish button (it has a Power BI logo with an upward arrow)

Option 2: From the File Menu

1. Click File in the top-left
2. Select Publish
3. Click Publish to Power BI

Choosing a Destination Workspace

After clicking Publish, a dialog appears asking where to publish your report.

You will see a list of workspaces available to your account:

• My workspace — Your personal workspace. Good for testing and personal reports. Cannot share with others on a free account.
• Team workspaces — Shared workspaces created for collaboration. Requires Pro or Premium license for members.

Select the appropriate workspace and click Select.

Power BI Desktop will show a progress bar while uploading. When complete, you will see a success message:

Publishing to Power BI — Success!
Open 'Your Report Name' in Power BI

Click the link to open your published report directly in Power BI Service.

Step 4: Understanding What Gets Published

When you publish a .pbix file, Power BI Service receives two separate items in your workspace:

Report — All your report pages, visuals, filters, slicers, and formatting. This is the interactive report users navigate through.

Dataset — The underlying data model — all your tables, relationships, measures, and calculated columns. This is what powers the report and gets refreshed on a schedule.

These two items appear separately in your workspace and can be managed independently. Multiple reports can connect to the same dataset.

Step 5: Navigating Power BI Service

After publishing, open app.powerbi.com in your browser and sign in with the same account.

The Power BI Service Interface

Home — Your frequently accessed reports, recently viewed items, and recommendations

Create — Start new reports, dashboards, and dataflows directly in the browser

Browse — Navigate your workspaces and find shared content

Workspaces — Your personal workspace and all team workspaces you belong to

Apps — Published app packages containing curated collections of reports and dashboards

Finding Your Published Report

1. Click Workspaces in the left navigation
2. Select the workspace you published to
3. You will see your Report and Dataset listed
4. Click the report name to open and view it

Step 6: Creating a Dashboard in Power BI Service

In Power BI, a dashboard is different from a report. Understanding this distinction is important:

• Report — Multiple pages of interactive visuals built in Power BI Desktop
• Dashboard — A single canvas of pinned tiles assembled from one or more reports in Power BI Service

Dashboards are created in Power BI Service by pinning visuals from reports. This is one of the key things you cannot do in Desktop.

How to Create a Dashboard by Pinning Visuals

Step 1: Open your published report

Navigate to your workspace and click the report to open it.

Step 2: Hover over a visual

Move your mouse over any chart, card, table, or map in the report. A set of icons will appear in the top-right corner of the visual.

Step 3: Click the Pin icon

Click the thumbtack/pin icon (it looks like a pushpin). A dialog will appear.

Step 4: Choose or create a dashboard

• New dashboard — Type a name and create a fresh dashboard
• Existing dashboard — Add this visual to a dashboard you already created

Click Pin.

Step 5: Repeat for all visuals you want on the dashboard

Pin as many visuals as needed from this report or from completely different reports. Dashboards can combine visuals from multiple reports and datasets.

Step 6: Open the dashboard

Click Go to dashboard in the confirmation message, or navigate to it from your workspace.

Arranging Dashboard Tiles

On the dashboard canvas:

• Drag tiles to rearrange their position
• Drag tile corners to resize them
• Click a tile to open the underlying report at that visual
• Right-click a tile for additional options — edit details, remove tile, set custom link

Adding Text and Image Tiles

Dashboards can include more than just pinned report visuals.

Click Edit → Add a tile on the dashboard to add:

• Text box — Add titles, descriptions, or instructions
• Image — Add your company logo or supporting images
• Web content — Embed a website or web app
• Video — Embed a YouTube or Vimeo video

Step 7: Configuring Data Refresh

One of the most powerful features of Power BI Service is scheduled data refresh — automatically updating your dataset from the original data source on a schedule you define.

Setting Up a Gateway (For On-Premises Data)

If your data lives in an on-premises database (SQL Server, Oracle, Excel files on a network drive), you need a Power BI Gateway — software installed on a machine in your network that securely connects Power BI Service to your local data sources.

For cloud data sources (Snowflake, BigQuery, Azure SQL, SharePoint Online), no gateway is needed.

Download and install the gateway:

1. In Power BI Service, click the Settings gear icon → Manage connections and gateways
2. Click New → On-premises data gateway
3. Download and install the gateway installer on a machine that can reach your data source
4. Register the gateway with your Power BI account during setup

Configuring Scheduled Refresh

1. Go to your workspace in Power BI Service
2. Find your Dataset (not the report — the dataset item)
3. Click the three dots (…) next to the dataset → Settings
4. Expand the Scheduled refresh section
5. Toggle Keep your data up to date to On
6. Choose your Refresh frequency:
   • Daily — up to 8 times per day (Pro), up to 48 times per day (Premium)
   • Weekly — specific days of the week
7. Set the Time zone for your schedule
8. Add specific refresh times (e.g., 7:00 AM, 12:00 PM, 6:00 PM)
9. Add an email notification address for refresh failure alerts
10. Click Apply

Checking Refresh History

To see whether refreshes are succeeding:

Dataset → Three dots → Refresh history

This shows each refresh attempt, whether it succeeded or failed, and the duration. If a refresh fails, the error message here tells you why.

Step 8: Sharing Your Report and Dashboard

Now that your report and dashboard are published and refreshing automatically, you need to get them in front of the right people.

Share a Report Directly

1. Open the report in Power BI Service
2. Click Share in the top toolbar
3. Enter email addresses of recipients
4. Configure permissions:
   • Allow recipients to share this report — They can forward access to others
   • Allow recipients to build content with the data associated with this report — They can create new reports from the dataset
5. Add an optional message
6. Click Send

Recipients receive an email with a direct link. They need a Power BI Pro license (or your workspace needs Premium capacity) to view shared content.

Share a Dashboard

1. Open the dashboard
2. Click Share in the top toolbar
3. Enter email addresses
4. Choose whether recipients can reshare
5. Click Send

Publish as an App (Best for Broader Distribution)

For distributing to a large audience, Power BI Apps are the recommended approach. An app is a curated package of reports and dashboards published from a workspace.

1. Go to your workspace
2. Click Create app in the top toolbar
3. Fill in app details — name, description, logo, contact information
4. Under Content — select which reports and dashboards to include
5. Under Audience — define who can access the app (specific people, groups, or your entire organization)
6. Click Publish app

Recipients install the app once and always see the latest version — no resharing needed when you update content.

Embed in SharePoint or Teams

SharePoint Online:

1. Open your report in Power BI Service
2. Click File → Embed report → SharePoint Online
3. Copy the embed link
4. Paste it into a SharePoint page using the Power BI web part

Microsoft Teams:

1. In a Teams channel, click + to add a tab
2. Search for and add the Power BI tab
3. Select your report
4. The report becomes a permanent tab in the channel

Step 9: Managing Workspace Permissions

If you are working with a team, properly managing who has access to your workspace is important.

Workspace Roles

Role	Can View	Can Edit	Can Publish	Can Manage Members
Viewer	Yes	No	No	No
Contributor	Yes	Yes	Yes	No
Member	Yes	Yes	Yes	Limited
Admin	Yes	Yes	Yes	Yes

Adding Members to a Workspace

1. Go to your workspace
2. Click Workspace access or the three dots → Workspace settings
3. Click Access
4. Type an email address or group name
5. Select their role from the dropdown
6. Click Add

Step 10: Republishing After Changes

When you update your report in Power BI Desktop and need to push changes to Power BI Service, simply publish again.

1. Make your changes in Power BI Desktop
2. Save the file (Ctrl + S)
3. Click Publish again
4. Select the same workspace
5. Power BI will ask: “Replace this dataset?” — Click Replace

Your report in Power BI Service updates immediately. Any dashboards with pinned tiles from this report also update automatically.

Important: Republishing replaces the dataset and report. If colleagues have added comments or created additional reports from the dataset, those are preserved. Pinned dashboard tiles update to reflect the new data.

Real-World Publishing Scenarios

Scenario 1: Weekly Sales Report for a Sales Team

A sales analyst builds a regional sales performance report in Power BI Desktop connected to a SQL Server database. They publish to a “Sales Team” workspace, schedule daily refresh at 7 AM, and share the dashboard with the sales director. The team sees fresh data every morning without the analyst doing anything manually after the initial setup.

Scenario 2: Executive Dashboard

A BI developer publishes five separate reports — Finance, Operations, HR, Sales, and Marketing — to an “Executive” workspace. They pin the most important KPI cards and charts from each report onto a single executive dashboard. The CFO opens one page and sees the company’s health across all departments at a glance.

Scenario 3: Client-Facing Reports

An analytics agency builds client reports in Power BI Desktop. They publish to separate workspaces per client, create apps for each client workspace, and share the app link with each client’s team. Updates to reports are instantly reflected in the app without any action from clients.

Common Mistakes to Avoid

• Publishing to My Workspace when collaboration is needed — My Workspace is personal. If teammates need access, publish to a shared team workspace instead
• Forgetting to configure data refresh — A published report with stale data is worse than no report. Always configure scheduled refresh immediately after publishing
• Not setting up a gateway for on-premises data — Without a gateway, scheduled refresh fails silently for local data sources. Install and configure the gateway before scheduling refresh
• Sharing individual reports instead of using Apps for large audiences — Direct sharing requires managing individual permissions. Apps scale much better for broad distribution
• Publishing without testing the report in Service first — Some features behave slightly differently in Service vs Desktop. Always review your report in the browser after publishing before sharing with stakeholders
• Not setting refresh failure notifications — If refresh fails and no one is notified, stakeholders see stale data without knowing it. Always add your email to refresh failure alerts

Publishing to Power BI Service is what transforms a local report file into a live, shared, automatically updating business intelligence asset.

Here is a quick recap of the full process:

• Sign in to Power BI Desktop and save your report
• Click Publish and choose your destination workspace
• Power BI Service receives your report and dataset as separate items
• Create a dashboard by pinning visuals from your report
• Configure scheduled data refresh — with a gateway if needed for on-premises data
• Share via direct link, workspace access, or publish as an App
• Manage workspace roles to control who can view and edit
• Republish from Desktop whenever you make changes

Once you have published your first report and seen it refresh automatically and appear on a colleague’s screen with live data — the power of Power BI Service becomes immediately clear. The build happens in Desktop. The impact happens in Service.

FAQs