aadsts900021: requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. tenant identifiers may not be an empty guid.

by

In this Azure article, we will discuss how to fix the error “Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID,” which I got while trying to connect to Azure SQL Database from the Power BI desktop application.

aadsts900021: requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. tenant identifiers may not be an empty guid.

Recently, I was working on a task where I was supposed to connect to the Azure SQL database from my Power BI desktop application. I got the above error when I tried to provide my Azure credentials and hit the sign-in button.

Below is the complete error message that I got.

Sorry, but we’re having trouble signing you in.

AADSTS900021: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID.

You can see it here

Requested tenant identifier '00000000-0000-0000-0000-000000000000' is not valid.

Why this error?

We are getting this error because the user is not set as Azure Active Directory admin yet with whom we are trying to connect to the Azure SQL database.

aadsts900021: requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. tenant identifiers may not be an empty guid.[Solution]

You can use the below simple steps to set the user as the Active Directory admin, which will quickly fix this error.

  • Navigate to the SQL server and click on the Azure Active Directory link from the left navigation. You can see the “No active Directory admin” option is enabled.
aadsts900021
  1. To set the admin, click on the Set Admin button.
Requested tenant identifier '00000000-0000-0000-0000-000000000000' is not valid

2. Select the AAD DC Administrators option and click the Select button.

requested tenant identifier '00000000-0000-0000-0000-000000000000' is not valid. tenant identifiers may not be an empty guid.

3. Then, make sure to click on the Save button to save the changes.

00000000-0000-0000-0000-000000000000

Now, you have set the Azure Active Directory admin successfully. Then try to sign in again from the Power BI Desktop application to connect to the Azure SQL database; this time, you won’t get the above error.

You may also like following the articles below

Wrapping Up

This is the way you can fix the error “Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID” using the above instructions. Thanks for reading this article !!!