# Connect Power BI to SharePoint > Automate data flow between SharePoint lists, libraries, and Power BI dashboards so your teams always work from a single source of truth. **Canonical page:** https://tray.ai/connectors/powerbi-sharepoint-integrations/ **Power BI connector:** https://tray.ai/connectors/powerbi-integrations/ **Power BI documentation:** https://tray.ai/documentation/connectors/service/powerbi **SharePoint connector:** https://tray.ai/connectors/sharepoint-integrations/ **SharePoint documentation:** https://tray.ai/documentation/connectors/service/sharepoint ## Overview Power BI and SharePoint are two of Microsoft's most widely used productivity tools, yet most organizations still move data between them by hand — exporting spreadsheets, uploading files, refreshing reports manually. Integrating the two builds a continuous, automated pipeline that turns raw SharePoint data into visual analytics without anyone lifting a finger. Whether you're tracking project milestones in a SharePoint list or managing inventory in a document library, tray.ai makes it easy to surface those insights directly inside Power BI dashboards. Organizations that rely on SharePoint for document management, project tracking, and team collaboration generate enormous amounts of structured data every day — and most of it stays invisible to the people making decisions. Power BI is built to visualize exactly this kind of operational data, but keeping dashboards current takes constant manual effort unless the two platforms are properly connected. Connecting SharePoint and Power BI through tray.ai lets teams automate dataset refreshes, push updated SharePoint list data into Power BI models on a schedule or in real time, and embed live reports back into SharePoint pages where work actually happens. The result is faster decisions, less reporting overhead, and a self-service analytics setup where any stakeholder can access accurate, up-to-date data without leaving the tools they already use. ## Use cases ### Automated SharePoint List Reporting in Power BI Many teams track projects, tasks, and resources in SharePoint lists, but visualizing trends and KPIs means manually exporting data into spreadsheets. By connecting SharePoint lists directly to Power BI datasets, tray.ai makes sure every new or updated list item shows up in your dashboards automatically. Stakeholders get real-time visibility into project health, task completion rates, and resource allocation without waiting for a weekly report. - Eliminate manual CSV exports and copy-paste errors from SharePoint to Power BI - Dashboards reflect live SharePoint list data without scheduled human intervention - Project managers get real-time KPI visibility without leaving their SharePoint environment ### Scheduled Power BI Dataset Refresh from SharePoint Files Teams frequently store Excel workbooks and CSV files in SharePoint document libraries as their primary data sources for Power BI reports. tray.ai can watch SharePoint libraries for new or modified files and automatically trigger a Power BI dataset refresh, so reports never display stale data. This removes the dependency on manual refreshes or complex gateway configurations. - Reports always reflect the latest version of SharePoint-hosted source files - Reduce reliance on on-premises data gateways for file-based refresh workflows - Finance and operations teams can update a single file in SharePoint and see dashboards update automatically ### Embed Power BI Reports Back into SharePoint Pages Once insights are generated in Power BI, teams often need to share them with stakeholders who live primarily in SharePoint. tray.ai can automate publishing updated report links or metadata back to SharePoint pages, news posts, or document libraries so reports are always discoverable in context. Data flows from SharePoint into Power BI, and insights flow back to where work happens. - Keep SharePoint intranet pages populated with the latest Power BI report links automatically - Drive report adoption by surfacing analytics inside SharePoint where teams already collaborate - Stop manually updating internal communications every time a dashboard URL changes ### Power BI Alerts Triggering SharePoint List Updates Power BI data alerts can notify teams when a metric crosses a threshold — when sales drop below target or inventory falls critically low, for example. By connecting Power BI alerts to tray.ai, those triggers can automatically create or update items in a SharePoint list, starting a structured response workflow directly in SharePoint. No more gap between spotting an alert and actually doing something about it. - Convert Power BI metric alerts into actionable SharePoint tasks or tickets automatically - Log and track critical threshold breaches in SharePoint for accountability - Speed up incident response by removing the manual step between seeing an alert and logging an action ### SharePoint Permissions and Governance Reporting in Power BI IT and compliance teams need to audit SharePoint site permissions, user access, and content changes regularly — but this data is hard to visualize natively. tray.ai can extract SharePoint permission and activity data on a schedule and push it into a Power BI dataset, enabling interactive governance dashboards. Administrators get a clear, always-current picture of who has access to what across their SharePoint environment. - Automate SharePoint audit data collection and Power BI ingestion for compliance reporting - Give IT teams interactive dashboards that surface permission anomalies and access risks - Replace manual audit spreadsheets with a continuously refreshed Power BI governance report ### Cross-Site SharePoint Data Aggregation for Consolidated Power BI Reports Large enterprises often run dozens of SharePoint sites across departments, each with independent lists and libraries holding related data. tray.ai can aggregate data across multiple SharePoint sites and consolidate it into a unified Power BI dataset, so executive-level reports can span the entire organization. No more piecing together disconnected site-level reports. - Unify data from multiple SharePoint sites into a single Power BI dataset without manual merging - Give leadership a consolidated view of operations across departments and geographies - Cut the number of disconnected reports by centralizing SharePoint data into one Power BI model ### New Power BI Workspace Provisioning Logged to SharePoint When new Power BI workspaces are created for teams or projects, IT and governance teams need to track the activity for licensing, access control, and auditing. tray.ai can automatically detect new workspace creation events in Power BI and write the relevant metadata — workspace name, owner, creation date, assigned users — to a SharePoint governance list. You get an always-current inventory of Power BI workspaces with no manual logging. - Maintain an accurate, automatically updated SharePoint inventory of all Power BI workspaces - Support Power BI license auditing and chargeback processes with structured SharePoint records - Give IT governance teams instant visibility into new workspace provisioning events ## Templates ### Sync SharePoint List Items to Power BI Dataset on Change This template monitors a specified SharePoint list for new or updated items and automatically pushes the data into a Power BI streaming dataset or triggers a dataset refresh, keeping dashboards current without manual intervention. Connectors used: SharePoint, Power BI ### Trigger Power BI Dataset Refresh When SharePoint File Is Updated This template watches a SharePoint document library for changes to Excel or CSV source files and automatically calls the Power BI API to refresh the dependent dataset, so reports always reflect the latest file version. Connectors used: SharePoint, Power BI ### Write Power BI Alert Events to SharePoint Action Log This template captures Power BI data alert notifications and automatically creates corresponding action items in a SharePoint list, so teams can track metric threshold breaches and assign follow-up owners directly within SharePoint. Connectors used: Power BI, SharePoint ### Aggregate Multi-Site SharePoint Data into a Consolidated Power BI Dataset This template queries multiple SharePoint sites on a recurring schedule, consolidates data from their respective lists, normalizes the schema, and pushes the unified dataset into Power BI for organization-wide reporting. Connectors used: SharePoint, Power BI ### Log New Power BI Workspace Creations to SharePoint Governance List This template detects when a new Power BI workspace is provisioned and automatically writes key metadata to a SharePoint governance list, maintaining a live inventory for IT auditing and license management. Connectors used: Power BI, SharePoint ### Publish Weekly Power BI Report Summaries to SharePoint News This template runs on a weekly schedule, retrieves key metrics from a Power BI report or dataset, and posts a formatted summary as a SharePoint news item so stakeholders stay informed without opening Power BI directly. Connectors used: Power BI, SharePoint ## Challenges Tray.ai solves ### Keeping Power BI Datasets Fresh as SharePoint Data Changes Continuously SharePoint lists and files are updated constantly throughout the day by multiple team members, but Power BI dataset refreshes are typically scheduled at fixed intervals or require manual triggering. This lag means dashboards can show outdated information during critical decision-making windows, and frequent refresh schedules can hit Power BI's API rate limits. **How Tray.ai helps:** tray.ai's event-driven architecture triggers a Power BI dataset refresh the moment a relevant SharePoint item changes, rather than waiting for a fixed schedule. Tray also handles retry logic and rate-limit backoff automatically, so refresh requests are queued and executed reliably without overwhelming the Power BI API. ### Handling Schema Mismatches Between SharePoint Columns and Power BI Fields SharePoint list columns often use data types, naming conventions, and multi-value formats that don't map cleanly to Power BI dataset schemas. Choice columns, person fields, lookup columns, and date formats frequently need transformation before Power BI can ingest them, and maintaining that transformation logic manually is error-prone as schemas change. **How Tray.ai helps:** tray.ai provides a visual data mapper and built-in transformation functions so teams can define and maintain field mappings between SharePoint and Power BI without writing custom code. When SharePoint columns change, the mapping can be updated in the tray.ai workflow editor without redeploying scripts or modifying gateway configurations. ### Authenticating Securely Across SharePoint and Power BI Without Exposing Credentials Both SharePoint and Power BI use Microsoft identity and OAuth 2.0, but managing service principal credentials, tenant IDs, and permission scopes across both services — especially in multi-tenant or multi-workspace enterprise environments — introduces real security and maintenance complexity. Hard-coded credentials in scripts or gateway configurations create audit and compliance risks. **How Tray.ai helps:** tray.ai stores all authentication credentials in an encrypted, centralized credential vault and uses OAuth 2.0 flows natively for both SharePoint and Power BI connectors. Teams can manage service principal permissions in one place, rotate credentials without touching individual workflows, and control who within tray.ai can use each authenticated connection. ### Aggregating Data Across Hundreds of SharePoint Sites at Scale Enterprise organizations may have hundreds of SharePoint sites, each with independently managed lists containing related but structurally varied data. Aggregating this for a consolidated Power BI report typically requires custom scripts, scheduled jobs, or complex Power Query M code — all brittle and hard to maintain as the number of sites grows. **How Tray.ai helps:** tray.ai supports dynamic looping and conditional branching, so a single workflow can iterate across a dynamically maintained list of SharePoint site URLs, query each one, normalize the output, and consolidate results before pushing to Power BI. Adding a new SharePoint site to the aggregation scope means updating a configuration list — no code changes needed. ### Knowing When Something Breaks Before a Stakeholder Notices a Stale Dashboard When SharePoint-to-Power BI sync workflows fail — due to API downtime, permission changes, or data validation errors — teams often have no idea until someone notices a stale dashboard. Silent failures in manual scripts or basic automation tools can go undetected for hours or days, and that erodes trust in the data fast. **How Tray.ai helps:** tray.ai provides detailed execution logs, step-level error visibility, and configurable alerting for every workflow run. When a SharePoint or Power BI API call fails, tray.ai can automatically retry the operation, route the failed record to an error-handling branch, and notify the responsible team via email or a messaging tool so nothing slips through unnoticed. ## Learn more - Intelligent Integration: https://tray.ai/platform/intelligent-ipaas/ - Merlin Agent Builder: https://tray.ai/platform/merlin-agent-builder/ - Agent Gateway for MCP: https://tray.ai/platform/agent-gateway/ - Book a demo: https://tray.ai/contact/