Skip to main content
Question

PowerBI Dataset imports

  • September 23, 2026
  • 1 reply
  • 19 views
Apprentice Author
Forum|alt.badge.img

Hello,

I would like to import data from a PowerBI Dataset - is it possible and if yes, what is the recommended way?

Note: the data set combines data from Snowflake, Excel files and managed rules by another planning group and therefore I want to leverage on this, rather than replicate.


Thanks

Remi.

    1 reply

    Employee
    Forum|alt.badge.img
    • zeke.gancenaEmployee
    • Employee
    • September 24, 2026

    Hey Remi! That makes complete sense why you’d be looking to export directly from PowerBI straight to Pigment. 

    You’ll probably need to set up an API workflow that will allow you to (1) get dataset from PowerBI (2) convert object into a CSV and then (3) import that CSV into Pigment via an API.

    For your consideration I’ve attached the two help articles here for you to reference:

    1. PowerBI Datasets - Get Datasets: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets
    2. Trigger an import and check status with APIs: https://kb.pigment.com/docs/trigger-import-apis

    You’ll want to use API orchestration tools (like n8n, workato, Postman flows, etc.) to achieve this.

    Ask your question here!

    Terms & ConditionsAccessibility statement