Power BI + SharePoint: Embedded Analytics Guide

The Power of Embedded Analytics

Combining Power BI with SharePoint brings data insights directly into your collaboration platform. Users can view dashboards and reports without leaving SharePoint, creating a unified workspace for content and analytics.

Embedding Options

1. Power BI Web Part

The simplest method for SharePoint Online:

Setup:

• Edit SharePoint page
• Add Power BI web part
• Select report from Power BI service
• Configure display options

Features:

• Full interactive reports
• Real-time data refresh
• Respects Power BI permissions
• Mobile responsive

Limitations:

• Requires Power BI Pro or Premium licenses
• Users need access to both SharePoint and Power BI

2. Embed for Your Organization

For internal users with Power BI licenses:

Implementation:

• Use Power BI publish to web (internal)
• Generate embed URL
• Add to SharePoint via iframe or web part
• Maintains RLS (Row-Level Security)

Best For:

• Dashboards for licensed users
• Secure internal reporting
• Interactive analysis

3. Embed for Your Customers (Power BI Embedded)

For external users or app embedding:

Implementation:

• Azure Power BI Embedded capacity
• App owns data model
• Custom authentication
• Per-session or per-user licensing

Best For:

• Customer-facing portals
• ISV applications
• External collaboration sites

Security Considerations

Power BI Permissions

Understand the permission layers:

• Workspace Access: Who can access the workspace
• Report Permissions: View, edit, share rights
• Row-Level Security: Data filtering by user
• Sensitivity Labels: Data classification

SharePoint + Power BI Security Matrix

| User Access | SharePoint Site | Power BI Report | Result |

|-------------|-----------------|-----------------|--------|

| Has both | ✅ | ✅ | Full access |

| SharePoint only | ✅ | ❌ | Shows error |

| Power BI only | ❌ | ✅ | Can't see page |

| Neither | ❌ | ❌ | No access |

Best Practice: Sync Permissions

Align SharePoint and Power BI access:

• Use same security groups
• Automate group membership
• Regular access reviews
• Document permission model

Implementation Guide

Step 1: Prepare Power BI Report

Before embedding, ensure:

• Report is published to Power BI service
• Appropriate workspace selected
• RLS configured if needed
• Performance optimized

Step 2: Configure SharePoint Page

Create or edit page:

• Navigate to target SharePoint site
• Create new page or edit existing
• Add Power BI web part
• Authenticate if prompted

Step 3: Select and Configure Report

In the Power BI web part:

• Browse available reports
• Select target report
• Choose specific page (optional)
• Set display size
• Configure interaction mode

Step 4: Test and Publish

Verify functionality:

• Check report loads correctly
• Test interactive features
• Verify on mobile devices
• Publish page

Advanced Scenarios

Dashboard Pages

Create SharePoint pages as dashboards:

• Multiple Power BI web parts
• KPI summaries at top
• Detailed reports below
• Quick filters section

Team Sites Integration

Embed reports in team collaboration:

• Project dashboards in team sites
• Department metrics in hub sites
• Executive summaries in communication sites

Automated Refresh

Configure data refresh:

• Scheduled refresh in Power BI service
• Gateway configuration for on-premises data
• Dataflow refresh for complex sources

Performance Optimization

Report Design

Optimize for embedding:

• Limit visuals per page (8-10 max)
• Use simple calculations
• Minimize custom visuals
• Pre-aggregate data where possible

Loading Experience

Improve perceived performance:

• Show loading indicators
• Load critical visuals first
• Use bookmarks for filtered views
• Cache frequently accessed reports

Licensing Requirements

Power BI Pro

• Required for sharing reports
• Per-user license
• Full authoring capabilities
• Suitable for most scenarios

Power BI Premium Per User

• Advanced features per user
• Larger model sizes
• Paginated reports
• AI capabilities

Power BI Premium Capacity

• Organization-wide embedding
• Dedicated compute resources
• Unlimited viewers (with SharePoint access)
• Best for large deployments

Troubleshooting

"You don't have access" Error

Check:

• Power BI service access
• Workspace permissions
• Report sharing settings
• Azure AD group membership

Report Not Loading

Verify:

• Browser compatibility
• Network connectivity
• Pop-up blockers disabled
• Power BI service status

Performance Issues

Address:

• Report complexity
• Data volume
• Refresh schedules
• Gateway capacity

Conclusion

Power BI and SharePoint integration delivers analytics where users work. Start with the Power BI web part for simplicity, and scale to embedded solutions as needs grow. Proper planning around security and licensing ensures successful deployment.

Our team can help design your embedded analytics strategy, from report optimization to enterprise-wide deployment.