Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hello,
I'm trying to get a list of pipelines using this:
Items - List Data Pipelines - REST API (DataPipeline) | Microsoft Learn
This is the behaviour I have noticed:
Workspace contains pipelines -> Status 200 OK
Workspace does NOT contain pipelines -> Status 401 Unautorized
Surely it should be 200 regardless of the content? Has anyone else noticed this? Is this a known issue?
Solved! Go to Solution.
Not the only inconsistency in the API responses.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
It turns out I got confused with what the service principal can and cannot access!
I first got a list of workspace ids using:
GET https://api.fabric.microsoft.com/v1/admin/workspaces
Then, I assumed I could get the list of pipelines within those workspaces using:
GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/dataPipelines
As it happens, the service principal had access to the workspaces containing pipelines but not the other ones (hence the confusion).
Now I know that I need to run an admin API call to get all pipelines from all workspaces (regardless of individual workspace permissions), such as:
GET https://api.fabric.microsoft.com/v1/admin/items?type=dataPipeline
Documentation here:
https://learn.microsoft.com/en-us/rest/api/fabric/admin/items/list-items
Thanks! I just wanted to double-check that I wasn't missing something before submitting a support ticket!
Not the only inconsistency in the API responses.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |