Skip to main content
Solved

PowerBI Dataset imports

  • September 23, 2026
  • 1 reply
  • 53 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.

Best answer by zeke.gancena

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.

View original

    1 reply

    Employee
    Forum|alt.badge.img+1

    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