SharePoint + Power BI Dashboard Integration

How Do You Embed Power BI Dashboards in SharePoint Online?

Power BI dashboards are embedded in SharePoint Online using the Power BI web part, which provides seamless, interactive report viewing directly within SharePoint pages without requiring users to navigate to the Power BI service. In our 25+ years managing enterprise SharePoint environments, we have integrated Power BI dashboards for organizations ranging from small departmental teams to Fortune 500 executive leadership portals, and the combination of SharePoint's reach with Power BI's analytical power consistently delivers the highest-impact business intelligence experiences.

Embedding Power BI in SharePoint transforms your intranet from a static content repository into a dynamic decision-making platform. Executives see real-time KPIs on their landing page, project managers monitor budgets alongside project documents, and department heads track team metrics in context with team communications.

Integration Methods

Method 1: Power BI Web Part (Recommended)

The Power BI web part is the simplest and most widely used integration method. Available on any modern SharePoint page, it embeds a published Power BI report with full interactivity — filtering, slicing, drilling, and exporting.

Setup Steps:

• Publish your Power BI report to the Power BI service (app.powerbi.com)
• Ensure the report is in a workspace that uses Power BI Pro or Premium capacity
• Share the report or workspace with the users who will view it on SharePoint
• Edit a SharePoint page, add the Power BI web part, and paste the report URL
• Configure display options (show/hide navigation pane, filter pane, page selection)
• Publish the SharePoint page

Key Configuration Options:

• Specific page: Link to a specific report page rather than the full report
• Filter pane: Show or hide the filter pane for end users
• Navigation pane: Show or hide page navigation
• Action bar: Show or hide the Power BI action bar (export, comment, bookmark)

Method 2: Embed Report URL in iFrame

For scenarios where the Power BI web part does not meet requirements, you can embed reports using the secure embed URL in an Embed web part. This provides more control over sizing and behavior but loses some native integration benefits.

Navigate to the report in Power BI service, click File > Embed report > Website or portal, copy the embed URL, and paste it into the SharePoint Embed web part.

Method 3: Power BI Embedded (Custom Development)

For fully customized analytics experiences, use the Power BI Embedded JavaScript SDK within a custom SPFx web part. This provides complete programmatic control over report rendering, filtering, theming, and interaction events.

This approach is appropriate when:

• You need to pass dynamic filters based on the current SharePoint context (current user, current site, current list item)
• You want custom navigation between multiple reports
• You need to combine Power BI visuals with custom UI elements
• You require advanced interaction patterns (cross-report filtering, custom drill-through)

The development effort is significantly higher than the standard web part, so use it only when the standard integration genuinely cannot meet your requirements.

Licensing Requirements

Power BI Pro

Every user who views a Power BI report embedded in SharePoint needs either:

• A Power BI Pro license ($10/user/month), OR
• Access through a Power BI Premium capacity ($4,995/month for P1 minimum)

With Pro licensing, each viewer needs their own license. For organizations embedding Power BI on broadly accessed SharePoint pages (intranet home page, all-hands landing page), Premium licensing is dramatically more cost-effective because any licensed Microsoft 365 user can view Premium-hosted reports without an individual Pro license.

Power BI Premium Per Capacity

Power BI Premium Per Capacity (P1 through P5) provides shared capacity for the entire organization. Reports published to Premium workspaces can be viewed by any Microsoft 365 user without Pro licenses. This is the standard choice for enterprise deployments where Power BI reports are embedded across the intranet.

Microsoft Fabric

In 2026, Power BI is part of the broader Microsoft Fabric platform. Fabric capacities (F2 through F2048) include Power BI capabilities alongside data engineering, data science, and real-time analytics. Organizations already using Fabric do not need separate Power BI Premium licensing.

Row-Level Security (RLS)

When Power BI reports are embedded in SharePoint, row-level security ensures each user sees only the data they are authorized to access. A single "Regional Sales" report embedded on the intranet automatically shows North America data to the NA sales team, Europe data to the EU team, and global data to executives — all from the same embedded report.

Implementing RLS

• Define roles in the Power BI Desktop data model using DAX filters (e.g., [Region] = USERPRINCIPALNAME())
• Map Azure AD users or security groups to roles in the Power BI service
• Test each role to verify data filtering works correctly
• Embed the report in SharePoint — RLS is automatically applied based on the viewing user

Dynamic RLS

For flexible security, use dynamic RLS that reads permissions from a security table in your data model. This table maps users to their authorized data scope (region, department, client, project). When the data model refreshes, permission changes in the security table take effect automatically without modifying DAX expressions.

Performance Optimization

Report Design for Embedding

Reports embedded in SharePoint should load fast — users expect sub-3-second rendering within a SharePoint page that already took 2-3 seconds to load. Optimize report performance:

Reduce visual count: Each visual on a report page generates separate queries against the data model. Limit to 8-10 visuals per page. If you need more visuals, use report page navigation to spread them across multiple pages.

Optimize DAX measures: Complex DAX calculations are the most common cause of slow report rendering. Use Performance Analyzer in Power BI Desktop to identify slow measures and optimize them. Pre-calculate in Power Query (M) what does not need to be calculated at query time.

Use aggregations: For large datasets (100M+ rows), configure aggregations in the data model. Aggregations serve summary queries from pre-computed tables, falling back to detail-level data only when users drill down.

Enable query caching: In Premium/Fabric capacity, enable query caching to serve repeated queries from cache rather than re-executing against the data model. This dramatically improves performance for reports viewed by many users with similar filter selections.

Page Load Optimization

The Power BI web part adds 2-5 seconds to SharePoint page load time depending on report complexity. Minimize impact:

• Place Power BI web parts below the fold so they load after the user sees the page
• Use the "Show filter pane" option sparingly — it adds render time
• For landing pages with multiple Power BI embeds, consider loading only one report initially and providing navigation to others

Enterprise Dashboard Architectures

Executive Dashboard Portal

Create a dedicated SharePoint communication site for executive dashboards. The home page provides a high-level KPI summary (revenue, pipeline, customer satisfaction, employee metrics) with navigation to detailed reports by function:

• Financial Performance (CFO view)
• Sales Pipeline (CRO view)
• Operations Metrics (COO view)
• People Analytics (CHRO view)
• IT Service Health (CIO view)

Each section embeds a Power BI report page tailored to that executive audience. RLS ensures each executive sees data appropriate to their role.

Departmental Analytics Hub

Embed Power BI reports on department hub sites so teams see their metrics alongside their collaboration tools. The Finance hub home page shows financial dashboards, the Sales hub shows pipeline reports, and the HR hub shows workforce analytics.

This brings analytics to where people work rather than requiring them to navigate to a separate analytics portal. Adoption rates are 3-5x higher when analytics are embedded in context versus isolated in a standalone BI portal.

Project Analytics Integration

Embed project-specific Power BI reports on project SharePoint sites. Connect Power BI to Project for the Web, Planner, or Azure DevOps to visualize project progress, budget burn, risk status, and resource utilization alongside project documents and team conversations.

Data Refresh and Governance

Scheduled Refresh

Configure data refresh schedules that align with business needs:

• Executive dashboards: 4x daily (every 6 hours)
• Operational reports: 2x daily (morning and evening)
• Financial reports: 1x daily (after overnight data processing)
• Monthly reports: Weekly or on-demand

Monitor refresh failures using Power BI service alerts and automate failure notifications to the BI team.

Dataset Governance

Implement governance for datasets that power embedded reports:

• Certify datasets that have been validated for accuracy
• Endorse datasets that are recommended for use but not yet certified
• Document data sources, refresh schedules, and ownership for every dataset
• Use Power BI lineage view to understand dependencies between datasets, reports, and dashboards

Workspace Organization

Organize Power BI workspaces to mirror your SharePoint architecture:

• One workspace per department or functional area
• Separate workspaces for development, staging, and production reports
• Use deployment pipelines to promote reports from dev to staging to production
• Assign workspace roles (Admin, Member, Contributor, Viewer) aligned with SharePoint permissions

Integrating Power BI with SharePoint Lists

Power BI can connect directly to SharePoint lists as a data source, enabling analytics on SharePoint data without data duplication.

Common Use Cases

• Help desk analytics: Connect Power BI to a SharePoint issues list to visualize ticket volume, resolution times, and trending categories
• Project portfolio reporting: Connect to project tracking lists across multiple sites for portfolio-level visibility
• Inventory management: Connect to inventory lists for real-time stock level dashboards
• Compliance tracking: Connect to audit and compliance lists for regulatory reporting

Performance Considerations

SharePoint lists as Power BI data sources work well for small to medium datasets (under 100,000 items). For larger datasets, consider extracting SharePoint list data to a dedicated database (Azure SQL, Dataverse) and connecting Power BI to that source for better query performance.

Our [SharePoint consulting team](/services/sharepoint-consulting) has designed and implemented Power BI integrations for enterprises across healthcare, finance, and government. We handle report development, embedding, RLS configuration, and performance optimization. Our [managed support services](/services/sharepoint-support) include ongoing dashboard maintenance and data refresh monitoring.

For organizations [migrating to SharePoint Online](/services/sharepoint-migration) and looking to modernize their analytics, we include Power BI integration planning as part of our migration methodology. [Contact us](/contact) for a Power BI integration assessment.

Frequently Asked Questions

Do all users need Power BI Pro licenses to view embedded reports?

No. If your Power BI reports are published to a Premium or Fabric capacity workspace, any Microsoft 365 licensed user can view embedded reports without a Pro license. Only report authors and editors need Pro licenses. This makes Premium capacity essential for intranet-embedded reports viewed by many users.

Can I embed Power BI paginated reports in SharePoint?

Yes. Paginated reports (RDL format) are embedded using the same Power BI web part. They are ideal for formatted, printable reports like invoices, statements, and regulatory filings. Paginated reports require Power BI Premium or Fabric capacity.

How do I filter a Power BI report based on the current SharePoint page context?

Use URL filter parameters in the Power BI web part. For example, append ?filter=Table/Column eq 'value' to the report URL. For dynamic filtering based on the current user or site, use a custom SPFx web part that reads the SharePoint context and applies filters programmatically through the Power BI JavaScript SDK.

Can users export data from embedded Power BI reports?

Yes, if the report settings and your tenant admin settings allow it. Users can export to Excel, CSV, PDF, and PowerPoint from embedded reports. You can disable export at the report level, workspace level, or tenant level if data should not leave the Power BI boundary.

What happens if the Power BI service is down?

If the Power BI service experiences an outage, the Power BI web part on SharePoint pages will show an error or blank space. The rest of the SharePoint page continues to function normally. Design critical pages with this in mind — do not make the Power BI embed the only content on a page that users depend on.

How do I troubleshoot slow Power BI embeds in SharePoint?

First, test the report directly in the Power BI service — if it is slow there, the issue is in the report, not the embedding. Use Performance Analyzer in Power BI Desktop to identify slow visuals and queries. If the report is fast in Power BI but slow in SharePoint, check the SharePoint page for other slow-loading web parts that may be competing for browser resources.

Can I schedule Power BI report snapshots for offline viewing in SharePoint?

Yes. Use Power Automate to export Power BI reports to PDF on a schedule and store the PDFs in a SharePoint document library. This provides offline access to report snapshots and creates a historical archive of reports for trend analysis.