调用PowerBi rest api并生成令牌

Question

我想调用PowerBIRESTAPI调用从本地/特定存储库上载pbix文件。

>

我应该如何生成承载令牌以供邮递员授权？

这个rest api调用是否可以用于generateToken？

此rest调用需要传递什么作为授权令牌？

myorg是PowerBI帐户名称吗？从哪里可以获取myorg值？

 POST https://api.powerbi.com/v1.0/myorg/GenerateToken

下面是我想通过邮递员调用的几个电话：

GET https://api.powerbi.com/v1.0/myorg/imports
GET https://api.powerbi.com/v1.0/myorg/reports/{reportId}

也很少打电话。

生成令牌的快速解决方案是什么？

Answer 1

您可以使用此功能请求访问

需要在azure中创建客户端IDhttps://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app?tabs=customers蔚蓝色的

    application_id= 'None'
    application_secret= 'None'
    user_id= 'None'
    user_password= 'None'

    accessToken = None 
    requestHeaders = None 
    tokenExpiry = None 
    accessToken_AD = None 
    requestHeaders_AD = None 
    tokenExpiry_AD = None 

     def pbi_auth(application_id,application_secret,user_id,user_password):
        global accessToken
        global requestHeaders
        global tokenExpiry
        data = {
            'grant_type': 'password',
            'scope': 'openid',
            'resource': "https://analysis.windows.net/powerbi/api",
            'client_id': application_id,
            'client_secret': application_secret,
            'username': user_id,
            'password': user_password
        }
        token = requests.post("https://login.microsoftonline.com/common/oauth2/token", data=data)
        assert token.status_code == 200, "Fail to retrieve token: {}".format(token.text)
        #print("Got access token: ")
        #print(token.json())
        accessToken = token.json()['access_token']
    
        requestHeaders= {
            'Content-Type': 'application/json; charset=utf-8',
            'Authorization': "Bearer {}".format(accessToken)
        }

    pbi_auth(application_id,application_secret,user_id,user_password)
    reportId= ""
    URI = "https://api.powerbi.com/v1.0/myorg/reports/{}".format(reportId)
    queryResults =  requests.get(URI, headers=requestHeaders)