This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hi,
I am trying to write Python code to trigger PowerBi dataset refresh. I have followed the online resources and written the below code. But I am getting a "Resource 403" error when I run this script.
import requests, json
import urllib
token_url = "https://login.microsoftonline.com/<tenant id>/oauth2/token"
test_api_url = "https://api.powerbi.com/v1.0/myorg/datasets/<dataset id>/refreshes"
client_id = 'client id'
client_secret = 'client secret'
data = {'grant_type': 'client_credentials'}
access_token_response = requests.post(token_url, data=data, verify=False, allow_redirects=False, auth=(client_id, client_secret))
print(access_token_response.text)
tokens = json.loads(access_token_response.text)
api_call_headers = {'Authorization': 'Bearer ' + tokens['access_token'], 'Content-Length': '1025'}
api_call_response = requests.post(test_api_url, headers=api_call_headers)
print (api_call_response)
Could you please help me with this?
Thanks in advance.
Hi @Anonymous ,
Please reference the similar threads:
https://community.powerbi.com/t5/Developer/403-Error-when-trying-to-access-REST-API/td-p/296324
https://community.powerbi.com/t5/Developer/Access-Power-BI-API-with-Python/td-p/189165
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 15 | |
| 11 | |
| 9 | |
| 8 | |
| 6 |
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 18 | |
| 15 | |
| 13 |