The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I need to know whitch dwh et fabric items i have in my workspace. How can i use the fabric api rest for that ?
Thanks
Solved! Go to Solution.
Hi @BenLyon ,
Thank you for reaching out to the Microsoft Fabric Community.
To find data warehouse extract-transform items in your Microsoft Fabric workspace, you can use the List Items API. This lets you pull a list of items in your workspace and filter by type — like DataPipeline or Dataflow. You just need to send a GET request to https://api.fabric.microsoft.com/v1/admin/items, including your workspace ID and item type in the URL, like this:
GET https://api.fabric.microsoft.com/v1/admin/items?workspaceId={your_workspace_id}&type=DataPipeline
Make sure you have the right permissions — either as a Fabric admin, Office 365 Global admin, or using a service principal and include the correct API permissions (Tenant.Read.All or Tenant.ReadWrite.All).
The response will give you useful details like the item’s ID, type, and status. If you have a lot of items, the API supports pagination to handle bigger lists.
As @lbendlin shared a documentation it explains this API and how to set it up. You can check it out here for more details.
I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi @BenLyon ,
Thank you for reaching out to the Microsoft Fabric Community.
To find data warehouse extract-transform items in your Microsoft Fabric workspace, you can use the List Items API. This lets you pull a list of items in your workspace and filter by type — like DataPipeline or Dataflow. You just need to send a GET request to https://api.fabric.microsoft.com/v1/admin/items, including your workspace ID and item type in the URL, like this:
GET https://api.fabric.microsoft.com/v1/admin/items?workspaceId={your_workspace_id}&type=DataPipeline
Make sure you have the right permissions — either as a Fabric admin, Office 365 Global admin, or using a service principal and include the correct API permissions (Tenant.Read.All or Tenant.ReadWrite.All).
The response will give you useful details like the item’s ID, type, and status. If you have a lot of items, the API supports pagination to handle bigger lists.
As @lbendlin shared a documentation it explains this API and how to set it up. You can check it out here for more details.
I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi @BenLyon ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi @BenLyon ,
I wanted to follow up on our previous suggestions regarding issue. We would love to hear back from you to ensure we can assist you further.
If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi @BenLyon ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
User | Count |
---|---|
19 | |
13 | |
6 | |
3 | |
3 |
User | Count |
---|---|
49 | |
25 | |
17 | |
12 | |
12 |