Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Abhilash_P
Kudo Kingpin
‎07-01-2025 07:14 AM

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

Abhilash_P_0-1751095733079.png

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.
    Abhilash_P_2-1751095914358.png

     

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).

Abhilash_P_3-1751095980441.png

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.

Abhilash_P_4-1751096051479.png


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.
    Abhilash_P_5-1751096102035.png


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.

Abhilash_P_6-1751096190831.png


 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

Abhilash_P_7-1751096308942.png


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.



 

Comments