Hi @SakethPatchava , Thank you for reaching out to the Microsoft Community Forum.
- To call the Power BI REST API, you must authenticate using OAuth 2.0. This involves obtaining an access token from Microsoft’s identity platform (Azure AD).
When you make a call to the Power BI REST API, Microsoft requires you to authenticate first. The Bearer token is like a digital key that proves your identity. You include this token in the Authorization header of each API call.
To get the Bearer Token, one needs to register an Application in Azure Active Directory, get necessary credentials, create a Client Secret, grant API Permissions and Once your app is registered and permissions are granted, you can generate a token by making a POST request to the OAuth 2.0 token endpoint. OAuth 2.0 Token Endpoint: POST https://login.microsoftonline.com/{tenantId}/oauth2/v2.0/token
When making API calls to Power BI, you need to include specific headers in your request. The header contains metadata about the request, such as the authentication token, the content type, and sometimes additional configuration details. Example: Content-Type: application/x-www-form-urlencoded
Example of Python Code to Get a Token:
import requests
tenant_id = "YOUR_TENANT_ID"
client_id = "YOUR_CLIENT_ID"
client_secret = "YOUR_CLIENT_SECRET"
token_url = f"https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token"
data = {
"grant_type": "client_credentials",
"client_id": client_id,
"client_secret": client_secret,
"scope": "https://api.powerbi.com/.default"
}
response = requests.post(token_url, data=data)
if response.status_code == 200:
access_token = response.json().get("access_token")
print("Access Token:", access_token)
else:
print("Failed to retrieve token:", response.text)
Once you have the token, you include it in the request header for all API calls. Example of Calling the Power BI REST API with the Token:
headers = {
"Authorization": f"Bearer {access_token}",
"Content-Type": "application/json"
}
workspace_id = "YOUR_WORKSPACE_ID"
api_url = f"https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/dataflows"
response = requests.get(api_url, headers=headers)
if response.status_code == 200:
print("Dataflows:", response.json())
else:
print("Failed to retrieve dataflows:", response.text)
- Fifth point is basically granting all required API Permissions, which is needed in getting bearer tokens. Here is how to do it:
In the Azure Portal, go to your Azure Portal -> Azure Active Directory -> App Registration -> Select your app -> API Permissions -> Add a Permission -> Power BI Service -> Select Dataflow.Read.All, Dataflow.ReadWrite.All -> Add Permissions -> Grant Admin Consent.
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
