Forum Discussion
Microsoft Fabric API: 400 Bad Request
You can create a lakehouse and other items using Service Principal. Please make sure below settings are enabled for Service Principal. Make sure Allow Service Principals to create and use Profiles enabled.
It's solved in this article: Solved: Re: Need help to create Lakehouse programmatically... - Microsoft Fabric Community
Hi dver344 ,
Base on your description, it seems like you got 400 bad request error when call Fabric API Items - List Lakehouses. A 400 Bad Request error typically indicates that the server cannot process the request due to client-side issues. Did you get the required permission and scope?
As I tested in my side, it can return the expected result...
Best Regards
Hi there!
Thanks for the response. I figured out the issue by looking closer at the response body:
Response body: {"requestId":"XXX","errorCode":"PrincipalTypeNotSupported","message":"The operation is not supported for the principal type"}
So basically, I've been using a service principal as suggested in the quickstart guide. I've been able to load lists of workspaces, items, ... and have already been able to create some cool powershell scripts with it. However, I'm unable to create items (lakehouses, notebooks, ...) dynamically due to this limitation. If I want to generate a token, I always need to use 'copy(powerBIAccessToken)' inside of the dev-tools in my browser itself.
The general Powershell functions to generate a new token via 'Get-PowerBIAccessToken' inside a powershell script doesn't seem to work. It states that if I do it via that way, I have insufficient permissions:
If I do it in the browser via 'copy(...)', and use that bearer token in my request, it will work and creates items, ...
Is there some news on this front as well? Why there is a difference between copy() via the DevTools in the browser compared to using the Get-PowerBIAccessToken inside your Powershell script? I'm logging in with the same user each time, so it shouldn't matter much.
Thanks!
You can create a lakehouse and other items using Service Principal. Please make sure below settings are enabled for Service Principal. Make sure Allow Service Principals to create and use Profiles enabled.
It's solved in this article: Solved: Re: Need help to create Lakehouse programmatically... - Microsoft Fabric Community
Can you help me with the powershell script. I tried, to get token from browser, n copy in script, but still it's 400 bad request error. I can get pipeline definition using same token, but creating any item using definition file I am receiving this error. Not much sure on how to use.platform and either items like.py or pipeline.json build definition file, and create item in fabric. Need help in creating items such as notebook, pipeline etc in fabric using powershell rest api. I have all my fikes in azure repo. With each file having.platform and json or .py files . kindly help
