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

问题描述

是否可以通过Azure数据工厂刷新Power BI数据集？

我发现有一个REST API（

2. 另一个用于调用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屋！