通过 Azure 数据工厂刷新 Power BI 数据集 [英] Refresh Power BI dataset through Azure Data factory

问题描述

有没有办法通过 Azure 数据工厂刷新 Power BI 数据集?

我发现有一个 REST API (

1. 另一个调用 POST API 来刷新数据集的 WEB 活动.在此，我通过了之前登录 Web 活动中捕获的身份验证令牌(请参阅下面的屏幕截图):

希望这会有所帮助！

如有任何问题，请随时与我们联系.

Is there a way to refresh Power BI dataset through Azure Data factory?

I found out that there is one REST API (https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/), which can be used to do this task but I am struggling to authenticate and pass an authorization token for the same.

Please suggest what other alternate options do we have?

解决方案

I was able to refresh my Power BI dataset from Azure Data Factory using Power BI REST API's (POST/GET), the challenge was to pass an authentication token so that I figured out can be done by capturing "access_token" in a separate activity and then pass it to the POST activity which actually refreshes the dataset.

Here is the flow:

1. Web Activity to get the token_type and access_token. I had to pass various parameters to pipeline (refer screenshot below).

URL: https://login.microsoftonline.com/common/oauth2/token

2. Another WEB activity to call POST API to refresh the dataset. In this I have passed the authentication tokens captured in previous Login Web activity (refer screenshot below):

Hope this helps!!

Feel free to reach out in case of any questions.

这篇关于通过 Azure 数据工厂刷新 Power BI 数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！