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/myorg/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?
