Seamless Power BI Report Management with SharePoint & OneDrive

Introduction to Power BI and Cloud Storage Integration
▪ Power BI allows integration with OneDrive/SharePoint for report storage.
▪ This integration facilitates automatic synchronization of reports, enhancing
collaboration and version control

Benefits of Cloud Storage Integration

• Automatic Sync: Changes to .pbix files sync to Power BI Service (~hourly).
• Collaboration: Share reports with team members via OneDrive/SharePoint.
• No Manual Publishing: Save changes directly, skipping “Publish” button.
• Version Control: Track and revert changes using cloud versioning.

Secure Storage: Cloud backups ensure accessibility and safety.

Setting Up Your Environment- Prepare Power Bi For Cloud Integration

1. Enable Power BI Features (Power Bi Desktop)

• File > Options and Settings > Options > Preview Features.
• Check: Save to OneDrive/SharePoint, Share to OneDrive/SharePoint, (Optional) Saving uploads in background.
  

   

2. Configure Tenant Settings (Power Bi Admin Portal)

• Users can view Power BI files saved in OneDrive and SharePoint (Preview Feature).
• Users can share links to Power BI files stored in OneDrive/SharePoint via Power BI Desktop (Preview Feature).

Semantic model owners can automatically update models based on changes in .pbix files stored in OneDrive or SharePoint.

Note: Option to enforce restricted updates across the organization (disable automatic updates for all semantic models).

3. Saving And Manage Reports

Create cloud folder and save reports in the cloud:

• Set up folder in OneDrive/SharePoint (e.g., “Power BI Reports”).
• Once the PBI report is ready, save to OneDrive/SharePoint:
  File > Save As > OneDrive/SharePoint, select folder, name file
• Organize Files: Use subfolders for projects/teams.
• Share Access: Grant permissions to collaborators.
• View Reports: Open .pbix files in browser for interactive previews.

4. Importing Reports To Power Bi Service

Bring Reports into Workspaces

   Go to Power Bi service:

• Workspace > Import > Report/Paginated Report/Workbook > OneDrive/SharePoint.
• Select .pbix file from cloud folder.
• Result: Imports report and semantic model into workspace.
  

5.Updating Reports Without Publishing

Seamless Report Updates

• Make Changes: Edit visuals, measures, model settings in Power BI Desktop.
• Save to Cloud: Click Save to update .pbix file.
• Automatic Sync: Power BI Service syncs changes (~hourly) if enabled.
  >By default, OneDrive updates files hourly; disable this in semantic model settings for manual updates (OneDrive refresh toggle).
• Manual Refresh: Click “Refresh” in semantic model for instant updates.
  >Semantic model owners and users with proper permissions can refresh by default; restrict this to owners only if needed (Sync with OneDrive/SharePoint settings).
• Example: Add DAX measure, mark date table, save, see changes in Service.
  
  

6. Configuring Data Refresh and Credentials

Keep Data Refresh

• Set Up Credentials: Semantic model settings, configure data source credentials.
• Schedule Refresh: Set data refresh schedule.
• OneDrive Sync Option: Enable/disable hourly sync for model/report changes.
  >Detailed settings for OneDrive refresh (toggle On/Off) and Sync with OneDrive/SharePoint (Restrict updates, Automatic updates, Default updates).
  >Semantic model owners vs. users with write permission: Restrict updates limits refreshing to owners; Automatic updates allows both to refresh.
• Monitor: Check refresh history for errors.

 When will the report changes reflect in Power BI Service?

If hourly sync is enabled → Power BI Service will automatically check your OneDrive/SharePoint file every hour and pull in those report changes (like new visuals/measures/layout changes).

If hourly sync is disabled (which is what that admin setting does — enforce restricted updates):

• The report changes will NOT reflect automatically.
  
• BUT — you can still do a manual dataset refresh from Power BI Service (click "Refresh now" on the dataset), and then the service will:
• Pull the latest .pbix file from OneDrive/SharePoint.
• Update the semantic model and report definition in the service with those changes you saved in your file.

No need to re-publish or use the Import button.
As long as your file is still connected via OneDrive/SharePoint, the manual refresh will sync it.

Power BI Dataset Update Settings: Automatic vs. Manual Options

Best Practices and Considerations
Tips for success

• Use Work Accounts: Avoid personal OneDrive for authentication.
• Control Sync: Disable automatic sync for sensitive reports.
• Manage Permissions: Restrict access to model owners or specific users.
• Enforce restricted updates at the tenant level to limit automatic updates organization-wide.
• Track Versions: Use OneDrive/SharePoint version history.
• Handle Limitations: On-premises data needs gateway, watch for expired tokens/sensitivity labels.