Forum Discussion

capradeep1984's avatar
capradeep1984
New Member
3 years ago

Power BI Dataset refresh through REST Api using Python

Hi Team,   I am unable to use Python to refresh the Power Bi using REST API. Need quick help.   My code snippet is as below: import requests import json import base64 # Set the API endpoint U...
APIS and Embedding
ibarrau's avatar
ibarrau
Super User
3 years ago

Hi. The way to connect to PowerBi Rest API is using an App Registered at Azure Active Directory. You won't be able to get a valid token without an app id. You will be able to use a user account or service principal as login with the app registered. Once the app is created it will require permission for read and write dataset in order to use the refresh action. The first part of the following post shows how to do it with Service Principal ( generating a key to login with that instead of a user ). Read more: https://blog.ladataweb.com.ar/post/642023841877671936/azuredatafactory-actualizar-powerbi-con

You can use libraries for this. Like: https://pypi.org/project/SimplePBI/

That might guide you a little on how to write the code or register the app on azure to start working.

I hope that helps,