Connect Power BI to Pigment and report from one plan
Bring forecasts, budgets, and scenarios from Pigment into the Power BI dashboards your business already reads through Pigment’s Export API, so reports show the same numbers as the plan. Built for FP&A teams who want to stop exporting files by hand, and for IT teams who need planning data to stay governed.

PowerBI
Load Pigment planning data into Power BI reports through the Pigment Export API
Category
Integration method
Best for
Executive dashboards · Variance reporting · Scenario reporting
What can you do with PowerBI and Pigment?
- Publish the latest forecast to leadership. An FP&A analyst loads the current forecast View into Power BI, where leadership sees it next to the visuals they already review, without opening Pigment.
- Review budget against actuals monthly. A finance business partner brings budget figures from Pigment into Power BI and compares them with the actuals the BI team already reports.
- Report on the scenario leadership chose. An FP&A manager sets the View's default items in page options, so Power BI receives the downside case instead of the default Scenario.
- Reuse one report setup across Views. A BI lead splits the endpoint URL into parts in Power BI, then points an existing query at a new View by changing only the View ID.
How the PowerBI integration works
Power BI pulls data from Pigment through the Export API. A Workspace Admin or Security Admin creates an Export API key in Workspace Settings, which tells Pigment which Workspace is targeted and whose access rights apply.
In Power BI Desktop, you go to Get data > Other > Web and enter the endpoint https://pigment.app/api/export/view/{viewId}, using the View ID from the Pigment URL. You add an Authorization header with your key as a Bearer token, and Pigment returns a flattened CSV that Power BI imports as usual. Block exports need POST requests, which Power BI’s Get data from Web feature doesn’t support, so the integration always exports Views. The technical documentation covers each step.
Key capabilities
- Control who can connect. Only a Workspace Admin or Security Admin can create an Export API key, and each key returns only the data its owner can see in Pigment.
- Retire access on a set date. Set an expiration date when you create each Export API key, so old connections don't stay open indefinitely.
- Send only the data you choose. Pigment recommends a dedicated View for API export, which keeps the Dimensions and Metrics in Power BI deliberate.
- Report on any type of plan data. Export Metric, List, and Table Blocks through a View, so financial figures and reference data can both reach Power BI.
- Skip reshaping before you model. Exports arrive unformatted, with all Dimensions as rows and Metrics as columns, ready for Power BI's import steps.
Frequently Asked Questions
Can I send a Scenario other than the default to Power BI?
Yes. Exports from Blocks with Scenarios use the default Scenario, and you can send a different one by setting Default items in the page options.
Is there a limit on how often Power BI can query Pigment?
Yes. Pigment allows 500 requests per 5-minute window per IP address, so plan the number of queries and refreshes your reports run around that limit.
How does Power BI data stay current?
Each time the report’s data refreshes in Power BI, it requests the latest data from the Pigment View. Nobody exports or re-uploads a file between refreshes.
Related integrations
See Pigment in action
The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

From 8 days to 4 min
Update P&L actuals & financial forecasting
80%
Time cut on data aggregation
12 hours
Saved per month on executive reporting
6 days faster
For scenarios creation and analysis