从Azure数据工厂刷新Power BI数据集-如何授权使用REST API

问题描述:

我想触发Power BI数据集以刷新数据工厂管道中的最后一步.我正在使用语法来刷新组中的数据集:https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdatasetingroup.

I want to trigger a Power BI dataset to refresh as final step in my Data Factory Pipeline. I am using the syntax to refresh a dataset in a group: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdatasetingroup.

我已经能够在ADF中配置一个Web活动,以使用REST API触发我的数据集的刷新.但是,我首先需要使用AAD中Power BI应用中的clientID运行控制台应用脚本来接收授权令牌.我用这个令牌 作为我在ADF中的HTTP POST调用中的授权标头.该令牌仅可使用1个小时,因此这不是一个可持续的解决方案.

I already was able to configure a Web Activity in ADF to trigger the refresh of my dataset with REST API. Nevertheless I first need to run a console app script with the clientID from my Power BI app in AAD to receive the authorization token. I use this token as Authorization header in my HTTP POST call in ADF. The token is only valid for 1 hour, so this is not a sustainable solution.

是否有一种方法可以通过ADF通过Power BI应用进行身份验证,而无需使用Azure Batch服务来运行自定义脚本?

Is there a way to authenticate to the Power BI app through ADF without using Azure Batch service to run a custom script?

预先感谢

亲切的问候,

Jonas De Troyer

Jonas De Troyer


从文档来看,当前的网络活动不是其他身份验证方法. (https://docs.microsoft.com/zh-cn/azure/data-factory/control-flow-web-activity#authentication)

from documentation, currently web activity does not other authentication method. (https://docs.microsoft.com/en-us/azure/data-factory/control-flow-web-activity#authentication)

我想尝试一种可能是编写代码来使用新的刷新令牌动态创建链接服务的方法吗?

i think one way to try this maybe written code to dynamically create linked service with the new refreshed token?