Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 .
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
4 | |
2 | |
2 | |
1 | |
1 |