Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
I am using Graph Ql, I performing the different CRUD operation. When I am doing single update,insert and delete its working. But when I am trying with multiple rows I am not able to do. Did any one tried it ?
Solved! Go to Solution.
Hi @Anonymous
Thank you for being part of the Microsoft Fabric Community.
If your fabric graphql api allows array-based inserts, you can modify the mutation to accept multiple records:
******************************************************************
JSON
******************************************************************
{
"query": "mutation CreateEmployees($items: [EmpInput!]!) { createempinfo(items: $items) { Id Name Address } }",
"variables": {
"items": [
{"Address": "Pune", "Id": 1000, "Name": "Then"},
{"Address": "Paratwada", "Id": 1001, "Name": "Chetan"}
]
}
}
******************************************************************
If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.
Thanks,
Cheri Srikanth
Hi @Anonymous
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please accept as solution to help others benefit.
Thank you.
Hi @Anonymous
Thank you for being part of the Microsoft Fabric Community.
If your fabric graphql api allows array-based inserts, you can modify the mutation to accept multiple records:
******************************************************************
JSON
******************************************************************
{
"query": "mutation CreateEmployees($items: [EmpInput!]!) { createempinfo(items: $items) { Id Name Address } }",
"variables": {
"items": [
{"Address": "Pune", "Id": 1000, "Name": "Then"},
{"Address": "Paratwada", "Id": 1001, "Name": "Chetan"}
]
}
}
******************************************************************
If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.
Thanks,
Cheri Srikanth
Hello @Anonymous
You cannot use the automatically generated GraphQL mutations in Microsoft Fabric to perform inserts, updates, or deletes on multiple rows in a single call because each of those mutations requires a primary key value for one specific row.
Please accept this solution if this is helpful
I have used Id as primary key.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
6 | |
4 | |
4 | |
3 | |
3 |