Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I need to connect to my fabric data warehouse in dbt cloud.
As recommended, tried to set up a service principal in azure portal and add it to my fabric workspace.
There is one weird thing in between that I could not figure out!!
A prerequisite to use service principal is to use the admin portal to allow Service Principal to use the fabric APIs (something like this Microsoft Entra authentication in Synapse Data Warehouse - Microsoft Fabric | Microsoft Learn). Actually the account we used to create fabric capacity, has NO such settings. It does not look like at all the way it looks like here (About tenant settings - Microsoft Fabric | Microsoft Learn). What we see is like this (in german)
At the end of day, we tried to skip this stage, as we thought this permission is given by default. But in dbt cloud we cannot connect to Fabric DWH. And I assume the problem comes from not being able to edit the setting on Fabric API.
Why we cannot see the proper Admin Portal (even using the account which created fabric capacity)?
Thanks in advance,
Jalal
Solved! Go to Solution.
Hi @Jalalmn,
For your scenario, it means your account does not have premissions to view and manage tenant setting, currently this account can only view the fabric capacity related settings.
You can contact to the admin to modify the tenant setting -> 'service principal' usage related settings.
Admin API admin settings - Microsoft Fabric | Microsoft Learn
Notice:
It not means all the rest API support to use service principal authorization.
I'd like to suggest you check on the official document about detail fabric rest API page to confirm if the current rest API allow you to use service principal.
Regards,
Xiaoxin Sheng
Hi @Jalalmn ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Actually not.
The problem is that we have no access to Fabric admin 🙂
I mean, we try to create a fabric account using our admin email address, but everytime it fails during the step of setting environment and returns a long session error.
If we could create the fabric using our admin address, we would not create the fabric capacity using staff email address.
And we don't know yet how to solve it
Hi @Jalalmn,
For your scenario, it means your account does not have premissions to view and manage tenant setting, currently this account can only view the fabric capacity related settings.
You can contact to the admin to modify the tenant setting -> 'service principal' usage related settings.
Admin API admin settings - Microsoft Fabric | Microsoft Learn
Notice:
It not means all the rest API support to use service principal authorization.
I'd like to suggest you check on the official document about detail fabric rest API page to confirm if the current rest API allow you to use service principal.
Regards,
Xiaoxin Sheng
Perhaps this is a setting which is controlled by the Fabric administrator, not Capacity administrator. So you would need to talk with the Fabric administrator in your organization.
https://learn.microsoft.com/en-us/fabric/admin/microsoft-fabric-admin
Check out the October 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
2 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
11 | |
7 | |
6 | |
6 | |
4 |