Save the .pbix in a SharePoint library once, connect it from a workspace once, and every later save flows into the Power BI service automatically. A hands-on walkthrough with screenshots.
| Item | Detail |
|---|---|
| Level | Beginner – Intermediate |
| Time needed | 20–30 minutes |
| Tools | Power BI Desktop, SharePoint Online, Power BI service (app.powerbi.com) |
| Outcome | A report in a Power BI workspace that re-syncs from a .pbix in SharePoint about every hour |
1. The key idea
Common misconception: Uploading a .pbix to SharePoint does NOT make it appear in Power BI. You must connect the file from a Power BI workspace once (Import → SharePoint). After that, the service checks the file about every hour and syncs changes.
| Stage | What happens |
|---|---|
| 1. Author | Build the report in Power BI Desktop and save SalesDemo.pbix |
| 2. Store | Upload / save the .pbix into a SharePoint document library |
| 3. Connect | In a workspace: Import → Report, Paginated Report or Workbook → SharePoint → pick the file |
| 4. Sync | Power BI keeps a link to the file’s SharePoint item ID and runs a “OneDrive refresh” roughly every hour |
| 5. Update | Replace the file in SharePoint → report + semantic model in the service update automatically |
2. Prerequisites
| Requirement | Why |
|---|---|
| Power BI Desktop (latest) | To build and save the .pbix |
| Microsoft 365 work/school account with a Power BI licence | SharePoint / OneDrive for work or school options are disabled without a subscription |
| Edit access to a SharePoint document library | To store the .pbix |
| A Power BI workspace (My workspace or a shared one) | Where the report and semantic model are created |
| Not a Document Set folder, not personal OneDrive | Both are unsupported sources for this import |
3. Step 1 – Prepare sample data
Any data works. For this walkthrough, an Excel workbook with a single table named SalesTable (240 rows, Jan–Sep) was used.
| Column | Type | Example |
|---|---|---|
| OrderID | Whole number | 1001 |
| OrderDate | Date | 2026-03-14 |
| Region | Text | North / South / East / West |
| Product | Text | Laptop, Monitor, Keyboard… |
| Category | Text | Hardware / Accessories / Software |
| Units, UnitPrice, Revenue | Number | 5 × 14,000 = 70,000 |
Tip: Format the range as an Excel Table (Ctrl+T) so Power BI picks up a clean, named table in the Navigator.
4. Step 2 – Build the report in Power BI Desktop
| # | Action |
|---|---|
| 1 | Home → Get data → Excel workbook (or the Excel workbook tile on the start screen) |
| 2 | Enter the file path or click Browse… → select the workbook |
| 3 | Next → tick SalesTable in the Navigator → Load |
| 4 | In the Data pane tick Region + Revenue → a clustered column chart is created |
| 5 | Click an empty part of the canvas, tick Category + Revenue → second chart |
| 6 | Resize the visuals and save the file as SalesDemo.pbix |
Figure 1: Get Data (Power Query) → Excel workbook: enter the File path or use Browse…
Figure 2: Report with two visuals; Data pane fields and X/Y-axis wells highlighted
5. Step 3 – Put the .pbix in SharePoint
Two ways to get the file into the library:
| Option | How | Best for |
|---|---|---|
| A. Browser upload | SharePoint library → Create or upload → Files upload → pick SalesDemo.pbix | One-off upload of an existing file |
| B. Save from Desktop | Power BI Desktop → File → Save as → SharePoint → choose site & folder | Ongoing work: every Ctrl+S writes straight to SharePoint |
Figure 3: Option A – the .pbix in the SharePoint library folder (Create or upload highlighted)
Figure 4: Option B – File → Save as → SharePoint lists your sites directly in Power BI Desktop
Watch out: libraries that require check-out
If the library has “Require documents to be checked out before they can be edited” set to Yes, a newly uploaded file stays checked out to you as a draft (version 0.1). Power BI and other users only see the last checked-in version.
| Symptom | Fix |
|---|---|
| File shows a checked-out icon / “Checked Out To” = you | Select the file → ⋯ → More → Check in → choose Major version |
| Changes saved but Power BI never picks them up | Check the file in after every upload or save |
| Want to avoid this entirely | Use a library where Require Check Out = No (Library settings → Versioning settings) |
Figure 5: Library settings → Versioning settings → Require Check Out
6. Step 4 – Connect the file from the Power BI service
| # | Action |
|---|---|
| 1 | Open app.powerbi.com → go to the target workspace |
| 2 | Import → Report, Paginated Report or Workbook → SharePoint |
| 3 | In Select a file, pick the site (Quick access or More places…) → Documents → PowerBI folder |
| 4 | Select SalesDemo.pbix → Upload |
| 5 | The workspace now shows a Report and a Semantic model, both named SalesDemo |
Figure 6: Workspace → Import → Report, Paginated Report or Workbook → SharePoint
Figure 7: Select a file: site → Documents → PowerBI → SalesDemo.pbix → Upload
Figure 8: Result: SalesDemo report + SalesDemo semantic model in the workspace
Note: “From this computer” uploads a copy with no link back. Only the OneDrive and SharePoint options create the synced connection.
7. Step 5 – Turn on automatic sync
Both settings live on the semantic model, not on the report.
| # | Action |
|---|---|
| 1 | Hover the SalesDemo row of type Semantic model → ⋯ (More options) → Settings |
| 2 | Scroll the left menu to OneDrive and SharePoint and expand it |
| 3 | Sync mode → select Automatic updates |
| 4 | OneDrive refresh → make sure the toggle is On (it also shows the linked SharePoint location) |
| 5 | Settings save immediately – there is no Apply button in the side pane |
Figure 9: Semantic model → ⋯ → Settings
Figure 10: OneDrive and SharePoint → Sync mode → Automatic updates
Figure 11: OneDrive and SharePoint → OneDrive refresh → On (location redacted)
Sync mode options explained
| Option | Behaviour | When it applies |
|---|---|---|
| Restrict updates | Only the semantic model owner can pull file changes, and only by a manual refresh | Default for every NEW semantic model |
| Automatic updates | Service updates automatically from the file; users with write permission can refresh | Choose this for hands-off sync |
| Default updates | Legacy behaviour kept for older models | Existing models only; disappears once you change the setting |
Admin dependency: If Automatic updates is greyed out, a Fabric admin must enable the tenant setting “Semantic model owners can choose to automatically update from files imported from OneDrive or SharePoint”.
8. Step 6 – Verify
| Check | Where |
|---|---|
| Report opens and shows the visuals | Workspace → SalesDemo (Report) |
| Sync history | Semantic model → ⋯ → Refresh history → OneDrive tab |
| Linked file location | Semantic model → Settings → OneDrive refresh |
| End-to-end test | Change a visual in Desktop → save/replace in SharePoint → check in → wait up to ~60 min |
Figure 12: The SalesDemo report rendered in the Power BI service
9. Two different “refreshes” – don’t mix them up
| OneDrive refresh (file sync) | Data refresh (semantic model) | |
|---|---|---|
| What it updates | Report pages, visuals, measures, model structure from the .pbix | Data rows from the original data sources |
| Reads from | The .pbix file in SharePoint / OneDrive | The sources (Excel, SQL, …) – NOT the .pbix |
| Frequency | About every hour, automatic | Manual (Refresh now) or a schedule you configure |
| Writes back to the .pbix? | No | No – refreshed data stays in the service |
| Needs a gateway? | No | Yes, if any source is on-premises or a local file path |
Tip: If your Excel source sits on a local drive, scheduled data refresh fails without a gateway. Store the source workbook in SharePoint too and connect with Get data → SharePoint folder (or Web with the file URL) so the service can refresh it with cloud credentials.
10. What breaks the link? Rename, move, copy
Power BI tracks the file by its SharePoint/OneDrive item ID, not by its name or path.
| Action on the .pbix | Item ID | Sync keeps working? |
|---|---|---|
| Rename in SharePoint (⋯ → Rename) | Same | Yes |
| Move to another folder/library (Move to, drag & drop) | Same | Yes (documented) |
| Upload a new version with the same name → Replace | Same | Yes – recommended way to update |
| Save from Desktop directly to the SharePoint file | Same | Yes |
| Save As a new name in Desktop and upload | New | No |
| Copy the file, or copy another file over it | New | No (documented) |
| Delete and re-upload, even with the same name | New | No |
Remember: Renaming the file does not rename the report or semantic model in the service – rename those separately (⋯ → Rename). If the link breaks, import the file again and re-apply Sync mode = Automatic updates on the new semantic model.
11. Troubleshooting
| Problem | Likely cause | Fix |
|---|---|---|
| Changes don’t appear after an hour | Sync mode still Restrict updates | Set Automatic updates, or owner runs Refresh now |
| Changes don’t appear (check-out library) | New version not checked in | Check in as a major version |
| Changes don’t appear | Power BI lost its connection to OneDrive/SharePoint (e.g. credentials changed) | Re-import the file; choose “Keep me signed in” when prompted |
| Automatic updates option disabled | Tenant setting enforces restricted updates | Ask the Fabric admin to enable the owner-choice setting |
| Refresh fails after sync | Data source credentials missing / gateway offline | Semantic model → Settings → Data source credentials / gateway |
| Link broken after copying the file | Copy creates a new item ID | Use Replace or Move instead; re-import if already broken |
| File not selectable in the picker | Stored in a Document Set or personal OneDrive | Move it to a normal library folder in OneDrive for work or school / SharePoint |
| Downloaded live-connection report won’t re-sync | Connection string incompatible after download | Open in Desktop, reconnect to the semantic model, save again |
12. Quick checklist
- Build and save the .pbix in Power BI Desktop
- Upload or Save as → SharePoint (normal library, not a Document Set)
- Check the file in if the library requires check-out
- Workspace → Import → Report… → SharePoint → select the file
- Semantic model → Settings → Sync mode = Automatic updates
- Confirm OneDrive refresh = On
- Update by replacing the same file – never copy or Save As
- Verify in Refresh history → OneDrive tab
No comments:
Post a Comment