I am internal user but database lists me as an external user

[bhope]

Hello, I'm testing out fabric so there's only a single user which is me I am the admin.

I've set up a data warehouse and a sql database. But I cannot seem to grant permissions to myself, even though I created a profile and assigned myself to that profile

I did a little deeper digging, and it shows that I'm an external user, even though in Azure and everywhere else I'm considered a member and an internal user. 

I used this query to determine my status and it returns external user and external for authentication type.  is there something I'm not understanding about the way fabric works? I can insert an update data using sql but the issue is I tried to create an app registration along with a managed identity to allow application interactions but I cannot assign the app crud operation ability.  And when I look at my own user, it says that I am external.

Any help would be greatly appreciated.

SELECT name AS username,

type_desc AS type,

authentication_type_desc AS authentication_type

FROM sys.database_principals

WHERE name = CURRENT_USER;

[v-vpabbu]

Hi @bhope,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Vinay Pabbu

[v-vpabbu]

Hi @bhope,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

Vinay Pabbu

[v-vpabbu]

Hi @bhope,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Vinay Pabbu

[v-vpabbu · Accepted solution]

Hi @bhope,

Thank you for reaching out to Microsoft Fabric Community Forum.

The issue occurs because your user authentication in the database is being recognized as "external," likely due to mismatches between how your Azure AD account is configured and how Microsoft Fabric handles authentication. This can happen if your account is treated as a guest in Azure AD, if there’s a tenant misalignment, or if the database interprets token-based authentication as external.

Verify Microsoft Fabric Workspace Permissions: Microsoft Fabric permissions may not correspond with Azure AD permissions.

Access the Fabric Admin Portal: Go to Settings > Users > Permissions and ensure you are listed as an admin or a user with the appropriate roles.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to give "Kudos"

Regards,
Vinay Pabbu

[bhope]

Yeah I looked into that inside of azure I am a member of org my profile is admin and I appear normal everywhere else I haven't had time to fully investigate but one thing I noticed running some powershell is that my profile didnt have a member designation instead it somehow was blank on back end even though in azure it shows as member could there be other settings that may need. configuring ?

Additionally this is where I was led after realizing I couldnt grant any db permissions using SQL even though I am admin, creating a profile to assign persmissions using SQL didnt work either.

[v-vpabbu]

Hi @bhope,

The blank UserType is a clear indication that there’s a backend discrepancy affecting your permissions and ability to manage the SQL database.

Collect logs from both PowerShell and SQL queries.
Contact Microsoft Support to investigate the backend user attribute issue.

Please refer below link on how to raise a contact support or support ticket.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Thankyou