Power BI Publishing Reports

Building a report in Power BI Desktop is the first half of the process. The second half is publishing that report to Power BI Service so other people can access it, and so you can set up automatic data refresh. Publishing makes your report available through a browser — no Power BI Desktop installation required for viewers.

What Happens When You Publish

Publishing uploads your Power BI Desktop file (.pbix) to Power BI Service — the cloud platform at app.powerbi.com. Power BI Service stores a copy of your report and, if you are using Import Mode, a copy of your data at that point in time.

After publishing, two separate items appear in your Power BI Service workspace: a Dataset (the data model and its data) and a Report (the visuals and pages you built). These two items are linked — the report reads from the dataset.

When you update and republish the report, both the dataset and report update in the cloud. Viewers who had the report open in their browser see the updated version the next time they refresh their browser.

Publishing from Power BI Desktop

Open your completed report in Power BI Desktop. Click the Home tab in the ribbon. Click the Publish button. A dialog appears asking you to select a destination workspace.

Workspaces are organizational containers in Power BI Service where reports and datasets are stored. Your personal "My Workspace" is available by default. If your organization has set up shared team workspaces, they appear in the list as well.

Select the appropriate workspace and click Select. Power BI Desktop connects to Power BI Service and uploads the file. A progress indicator appears. When complete, a success message appears with a link to open the published report directly in your browser.

Workspaces — Organizing Your Published Content

My Workspace is private — only you can see what you store there. Shared workspaces allow teams to collaborate. Members of a workspace can view, edit, and manage the reports and datasets inside it, depending on their assigned role.

Workspace roles determine what each member can do:

• Admin: Full control — add and remove members, publish, delete, and edit everything.
• Member: Can publish reports, create and edit content, but cannot manage workspace membership.
• Contributor: Can create and edit content but cannot publish to apps or delete workspace items.
• Viewer: Can only view published content. Cannot make any changes.

Create a dedicated workspace for each project or department. For example: "Sales Analytics Workspace," "HR Dashboard Workspace," "Finance Reports Workspace." This separates content by audience and avoids clutter in one shared space.

Setting Up Scheduled Data Refresh

When you publish a report using Import Mode, the cloud copy of your data is a snapshot taken at publish time. It does not update automatically unless you configure scheduled refresh.

Scheduled refresh connects Power BI Service back to your original data source and retrieves fresh data on a timed schedule — daily, twice daily, or up to eight times daily depending on your license.

Step 1 — Set Up a Data Source Gateway (if needed)

If your data source is a local file on your computer or a database inside your company network (not in the cloud), Power BI Service cannot reach it directly. You need to install a Power BI Gateway — a software bridge that sits on your company network and securely passes data to Power BI Service when a refresh is triggered.

For cloud-based sources like SharePoint Online, Azure SQL, or Salesforce, no gateway is needed — Power BI Service connects to them directly using stored credentials.

Step 2 — Enter Data Source Credentials

In Power BI Service, go to your workspace and find the dataset (not the report — the dataset). Click the three-dot menu next to the dataset and select Settings. Find the Data Source Credentials section. Click Edit Credentials and enter the login details for your data source. Power BI Service stores these credentials securely and uses them during scheduled refreshes.

Step 3 — Configure the Refresh Schedule

In the same Settings page, find the Scheduled Refresh section. Toggle it On. Choose your refresh frequency — Daily, and then specify the times you want the refresh to run. For example, set it to refresh at 6 AM every day so that when your team opens reports at 9 AM, they see data updated with last night's records.

On-Demand Refresh

Scheduled refresh runs automatically at the times you specify. But sometimes you need to refresh data right now — not wait until the next scheduled time. Find your dataset in the workspace, click the three-dot menu, and select Refresh Now. Power BI Service immediately connects to your data source and updates the dataset.

Republishing Updated Reports

When you make changes to the report in Power BI Desktop — add a new page, change a visual, update a DAX formula — you republish by clicking Publish again. Power BI asks if you want to replace the existing report. Confirm, and the cloud version updates.

Republishing replaces the report's visuals and pages. It does not reset the data refresh schedule or any permissions you configured in Power BI Service — those settings persist across republishes.

Version Control Consideration

Power BI does not have built-in version history for report files. If you publish an updated report and later discover the old version was better, you cannot roll back from within Power BI Service. Save a copy of your .pbix file locally before publishing changes. Name it with a date or version number — "SalesDashboard_v3_2024May.pbix" — so you have a clear history you can return to if needed.