Not sure if this is the right forum or not..,.
I'm attempting to use the Fabric API to pull data into a Fabric Lakehouse. I'm currently utizling a data pipeline with a copy activity, where the source is of type REST, and the destination is a lakehouse table within the same workspace.
I've set up a security group that includes my account as well as a service principal. This group has been granted the Admin role within the workspace, and I've also enabled the following permissions within the Fabric Tenant:
- Service principals can use Fabric APIs
- Service principals can access read-only admin APIs
- Enhance admin APIs responses with detailed metadata
- Enhance admin APIs responses with DAX and mashup expressions
Note that my account is also a Fabric Administrator.
I'm using the following API: https://api.fabric.microsoft.com/v1/workspaces
This API works seamlessly when I test it via the "Try It" feature on Microsoft Learn using my credentials. However, when I attempt to connect via the pipeline, the connection tests successful, however, I encounter a 403 error whenever I try to preview data or import a schema.
When I attempt to connect with the Service Principal the connection does not test successful. I am assuming this is API permissions not configured correctly on the applicaiton/sp.
I'm hoping this is just a matter of user error or a gap in my understanding. Looking for any insights or guidance on what migh be going wrong. I feel like I should be able to use my credentials to connect and successfully call the Fabric API.
