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.
With Powershell code, I successfully worked out to create a GraphQLApi as described
here: https://learn.microsoft.com/en-us/rest/api/fabric/graphqlapi/items/create-graphqlapi
However, I am unable to update its Definition using the following API:
https://learn.microsoft.com/en-us/rest/api/fabric/graphqlapi/items/update-graphqlapi-definition
More, precisely, I succeed if I use a near-empty graphql-definition.json file like the following:
{ "$schema": "https://developer.microsoft.com/json-schemas/fabric/item/graphqlApi/definition/1.0.0/schema.json" }
But if I try to use a real-case graphql-definition.json, got from my AzureDevops GIT (after a commit made on a hand-made GraphQL API), it fails with the following (not meaningful) response.
@{status=Failed; createdTimeUtc=07/22/2025 07:16:58; lastUpdatedTimeUtc=07/22/2025 07:16:59; percentComplete=; error=}
For completness, the following is the "graphql-definition.json":
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/graphqlApi/definition/1.0.0/schema.json",
"datasources": [
{
"connectionId": "<MY CONNECTION ID>",
"objects": [
{
"actions": {
"Query": "Enabled",
"Query_by_pk": "Enabled",
"Create": "Enabled",
"Update": "Enabled",
"Delete": "Enabled"
},
"fieldMappings": {
"A": "A",
"B": "B",
"C": "C"
},
"graphqlType": "TEST",
"relationships": [],
"sourceObject": "dbo.TEST",
"sourceObjectType": "Table"
}
],
"sourceItemId": "<MY WAREHOUSE ID>",
"sourceType": "Warehouse",
"sourceWorkspaceId": "<MY WORKSPACE ID>"
}
]
}
NOTE: For authenticating to the management API, I use a service principal.
Hi @Faber1975 ,
Yes the above few earlier suggestion are from copilot and in addition you can check out the below points as follows.
This approach that might help, start with your working “almost empty” GraphQL schema and slowly add sections of your full definition back in like the types, queries, and mutations bit by bit. This lets you narrow down exactly which part of the schema is causing the update to silently fail with that {status=Failed; error=} message.
It’s also a good idea to run your full 'graphql-definition.json' through a GraphQL validator.
You can use https://graphql-validator.com or tools like 'graphql-cli 'or 'graphql-js' if you're working locally.
If the issue still persists try to open a support ticket https://support.fabric.microsoft.com/support/
Regards,
Akhil.
Thanks Akhil, I'll try to "dissect" the json. It must be surely syntactically correct because it is automatically generated by Fabric when I commit my API to GIT.
Thank you for your reply.
Unfortunately your suggestions (AI generated?) do not apply:
- I have no linked services
- I use a service account, not a user account
- Permissions are ok: I can successfully invoke the Create Graph QL API, and I can also invoke the Update GraphQL API, passing an "almost empty" payload (see my 1st message).
- The Service Principal is not expired: I use it in all other pipelines
- In point 6 you talk about a Data flow, but I did not mention data flows (I have no data flows at all)
- I am not the admin, so I cannot access the activity logs.
Many thanks for your support. Fabrizio
Hi @Faber1975 ,
If you’re still facing any issues after that, feel free to let us know and we can troubleshoot further together.
Regards,
Akhil.
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
1 |
User | Count |
---|---|
15 | |
15 | |
11 | |
6 | |
6 |