Microsoft Power BI

What is the Microsoft Power BI Connection?

The Microsoft Power BI connection connects your Power BI account to Duvo, enabling your assignments to access datasets, reports, and workspaces for automated analytics and reporting. This is a user-configured connection -- you will need to authenticate with your Microsoft account before your assignments can use it.

What Can It Do?

The Microsoft Power BI connection provides actions that allow your assignments to:

• Access datasets: Retrieve data from your Power BI datasets for analysis and reporting

• Read reports: Pull report data and visualizations from your Power BI workspaces

• Browse workspaces: Discover available workspaces, datasets, and reports

Why This Matters

Power BI is a core analytics tool for many organizations, housing dashboards and reports that drive business decisions. The Power BI connection allows your assignments to access this analytics data directly -- pulling metrics for automated reports, checking KPIs for decision-making, and incorporating business intelligence into workflows without manual dashboard checks or screenshot sharing.

When to Use It

Use the Microsoft Power BI connection when your assignment needs to:

• Pull analytics data: Retrieve metrics and KPIs from Power BI for inclusion in automated reports

• Monitor business performance: Check dashboard data to trigger actions based on performance thresholds

• Generate summaries: Extract data from Power BI reports and compile it into written summaries or emails

• Combine analytics with action: Use Power BI data alongside other connections to make informed, automated decisions

How It Works

After connecting your Microsoft account, your assignments can access your Power BI workspaces, datasets, and reports using your credentials and permissions. When you include Power BI actions in your assignment's SOP, it will retrieve data just as you would -- browsing workspaces and pulling the metrics needed for workflow decisions.

Key Benefits

• Automated analytics access: Pull Power BI data into workflows without manual dashboard checks

• Real-time metrics: Access current analytics data rather than relying on periodic exports

• Your account, your control: Uses your Microsoft credentials with your existing permissions

• Business intelligence integration: Bring analytics data into automated workflows for smarter decisions

Works Well With

• Gmail or Microsoft Outlook: Pull Power BI metrics and include them in automated email reports to stakeholders

• Slack or Microsoft Teams: Query Power BI data and post performance summaries to team channels

• Google Sheets or Microsoft Excel: Export Power BI data into spreadsheets for further analysis or custom reporting