https://catalogartifact.azureedge.net/publicartifacts/ldc.api-button-atlas-3176f368-5604-4749-aed8-545d6cce7720/image0_icon300.png
API Button Atlas
durch Louis Dreyfus Company
Trigger authenticated API calls from a report
API Button turns a Power BI report into an action surface.
API Button is a Microsoft Power BI custom visual that adds a configurable button to your report. When a user clicks it, the visual sends an HTTP/HTTPS request to an API you choose and shows the response right inside the report. Users can run parameterized queries, generate and download files, start backend jobs, and trigger workflows — all without leaving Power BI.
Who it's for
API Button is built for Power BI report authors, BI developers, and data and analytics teams in organizations that already expose internal APIs or data services and want to connect them to their reports in a governed, self-service way. It is industry-agnostic and is used across sectors such as financial services, commodities and agriculture, supply chain and logistics, manufacturing, energy, and retail — anywhere teams need report-driven access to enterprise APIs, on-demand data exports, or operational triggers.
What you can do
- Call any HTTP/HTTPS endpoint you configure, using a static URL or a dynamic URL driven by a DAX measure.
- Send live report context as query parameters from measures and from data columns; slicer and filter selections automatically narrow what is sent.
- Add custom request headers from JSON or from measures, and choose GET, POST, PUT, or DELETE with query-only, JSON-body, or combined payloads.
- Display JSON and text responses inline, copy results to the clipboard, or open them in the browser.
- Handle real-world API patterns automatically with Auto-Detect: inline file downloads, binary content, asynchronous (HTTP 202) jobs with polling, redirects, and download-URL responses — including a cancel control for long-running jobs.
- Export response files through the Power BI download API, with an automatic browser fallback.
- Optionally turn a column's values into cross-filter chips that filter the report page like a slicer while also narrowing the request.
- Use built-in toast notifications, request tooltips, the standard right-click context menu, and an authentication diagnostics panel.
Authentication and security
Choose the auth mode that fits your API: a manual bearer token, or no authentication for public APIs. Tokens are held in memory only and are never sent to the publisher. API Button has no backend of its own — requests go only to the endpoint the report author configures, and the visual ships with no analytics, advertising, or tracking.
Supported Microsoft products and requirements
- Microsoft Power BI Desktop and the Power BI service.
- A reachable HTTP/HTTPS API or service that you configure, with CORS enabled for the Power BI environment.
The visual is configured entirely from the Power BI format pane — no installation, deployment, or code is required.
Things to know
- Microsoft Entra ID SSO is restricted at this time.
- Bearer tokens entered in the format pane are stored inside the Power BI report file (.pbix) in plaintext; use Microsoft Entra ID SSO for production scenarios.
- The Power BI export/download API is subject to Power BI's 30 MB file-size limit; a browser download is used as a fallback when needed.
Visuelle Funktionen
Hinweise für die Verwendung dieses Visuals:
- Zugriff auf externe Dienste oder Ressourcen möglich
Auf einen Blick
https://catalogartifact.azureedge.net/publicartifacts/ldc.api-button-atlas-3176f368-5604-4749-aed8-545d6cce7720/image1_Screenshot.png