Setup
Click Enable on the Connections page and authorize with your Microsoft account.Capabilities
- Browse workspaces and content — Discover available workspaces, datasets, and reports across your Power BI environment.
- Inspect dataset schemas — Retrieve table names, column names with data types, and measures from any dataset before querying.
- Run DAX queries — Execute DAX queries against your datasets and export the results as CSV for further analysis.
Key Benefits
- Automated analytics access — Pull Power BI data into workflows without manually checking dashboards or exporting files.
- Real-time metrics — Access current analytics data rather than relying on periodic exports or screenshots.
- Your permissions, your control — Uses your Microsoft credentials with your existing Power BI permissions and access levels.
- Business intelligence in every workflow — Bring analytics data into automated workflows for smarter, data-driven decisions.
Works Well With
Gmail
Pull Power BI metrics and include them in automated email reports to stakeholders.
Microsoft Outlook
Pull Power BI metrics and include them in automated email reports to stakeholders.
Slack
Query Power BI data and post performance summaries to team channels.
Microsoft Teams
Query Power BI data and post performance summaries to team channels.
Google Sheets
Export Power BI data into spreadsheets for further analysis or custom reporting.
Microsoft Excel
Export Power BI data into spreadsheets for further analysis or custom reporting.