Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join now60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more
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 .
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 5 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |