Issue:
I am calling the Fabric Dataset API using a Service Principal (WinsightsBlazor
) for datasets inside the same workspace, but encountering inconsistent behavior:
✅ Works for dataset ID: 254e59de-a6de-4f33-9adf-3d96a406540c
(NRT)
❌ Fails with 401 Unauthorized for dataset ID: fbbcf948-ed4e-4dcf-b74a-51742f913d5b
(Winsights_SemanticModel)
API Endpoint Used:
POST .0/my/groups/{workspaceId}/datasets/{datasetId}/executeQueries
Steps Taken:
- Configured API Permissions: Granted all necessary API permissions to the Service Principal.
- Raised a Support Ticket: Requested REST API access to be enabled for the Service Principal.
Question:
- Why does the API call work for one dataset but fail for another inside the same workspace?
- Are there additional permissions or configurations required specifically for certain datasets?