cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
oflok000 Frequent Visitor
Frequent Visitor

access token power bi python

Hello

I wrote code using sample on python. All the time I have 400 Bad request. Where can be problem?

import urllib
import json
import requests

url = 'https://login.microsoftonline.com/common/oauth2/token'
data = {
    'grant_type':'password',
    'scope':'openid',
    'resource':'https://analysis.windows.net/powerbi/api',
    'client_id':'here id',
    'client_secret': 'here secret',
    'username':'here username',
    'password':'here password'
       }
response = requests.post(url,data=data)
#print(data)
print(response);
1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: access token power bi python

Hi @oflok000,

And to add to that post, everything about authentication using .NET should work just as well with the equivalent Python library adal - https://github.com/AzureAD/azure-activedirectory-library-for-python

According to this similar thread, you should be able to use the Python library adal to get the access token with Power BI Rest API. The sample code below is for your reference. Smiley Happy

import adal

authority_url = 'https://login.microsoftonline.com/testcompany.onmicrosoft.com'
context = adal.AuthenticationContext(
    authority_url,
    validate_authority=True,
    api_version=None
)

token = context.acquire_token_with_username_password(
    resource='https://analysis.windows.net/powerbi/api',
    username='john.doe@testcompany.onmicrosoft.com',
    password='secret',
    client_id='22a6fc5a-46fe-4f85-8168-281ece441742'
)

access_token = token['accessToken']

 

Regards

1 REPLY 1
v-ljerr-msft Super Contributor
Super Contributor

Re: access token power bi python

Hi @oflok000,

And to add to that post, everything about authentication using .NET should work just as well with the equivalent Python library adal - https://github.com/AzureAD/azure-activedirectory-library-for-python

According to this similar thread, you should be able to use the Python library adal to get the access token with Power BI Rest API. The sample code below is for your reference. Smiley Happy

import adal

authority_url = 'https://login.microsoftonline.com/testcompany.onmicrosoft.com'
context = adal.AuthenticationContext(
    authority_url,
    validate_authority=True,
    api_version=None
)

token = context.acquire_token_with_username_password(
    resource='https://analysis.windows.net/powerbi/api',
    username='john.doe@testcompany.onmicrosoft.com',
    password='secret',
    client_id='22a6fc5a-46fe-4f85-8168-281ece441742'
)

access_token = token['accessToken']

 

Regards

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 94 members 1,535 guests
Please welcome our newest community members: