In this Azure article, we will discuss how to resolve the error “Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID” that I encountered while attempting to connect to Azure SQL Database from the Power BI desktop application.
Table of Contents
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 that required me to connect to an Azure SQL database from my Power BI desktop application. I encountered the above error when I attempted to provide my Azure credentials and clicked 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
Why this error?
We are encountering this error because the user has not been set as an Azure Active Directory admin yet, with whom we are trying to connect to the Azure SQL database.
Solution
You can use the steps below to set the user as an Active Directory admin, which will quickly resolve this error.
- Navigate to the SQL server and click on the Azure Active Directory link from the left navigation. You can see that the “No active Directory admin” option is enabled.
- To set the admin, click on the Set Admin button.
2. Select the AAD DC Administrators option and click the Select button.
3. Then, click the Save button to save the changes.
Now, you have successfully set up the Azure Active Directory admin. Then, try signing in again from the Power BI Desktop application to connect to the Azure SQL database; this time, you won’t encounter the above error.
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 !!!
You may also like the following articles below
- An error happened while reading data from the provider: While connecting to Azure SQL Database from Power BI
- Cannot Open Server Requested By The Login Azure SQL
I am Rajkishore, and I am a Microsoft Certified IT Consultant. I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machines, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.
