PowerBi Dataset Refresh Failed With Error {"Message":"Request is blocked by the upstream service"} And Error Code: 2108

Devaraju Sankruth 0

Hi,
While Trying to refresh the powerbi dataset through rest api's from ADF.I'm getting the Following Error. DatasetId and WorkSpaceId Provided are Correct.

QuantumCache 20,261 Reputation points

2023-10-28T00:03:43.2266667+00:00

Hello @Devaraju Sankruth Welcome to QnA forum.

Did you try the PowerBi Refresh outside ADF? such as Postman, manual or other methods?

Authentication issue: Make sure that the authentication details provided in the REST API call are correct and have the necessary permissions to refresh the Power BI dataset. You can try refreshing the dataset manually in Power BI to ensure that the authentication details are correct.

Check if there are any network issues that could be causing the request to be blocked. You can try running the REST API call from a different network or location to see if the issue persists.
Devaraju Sankruth 0 Reputation points

2023-10-28T03:18:22.8566667+00:00

Below is my pipeline1st web activity starts the refresh, execute pipeline inside the if condition checks the refresh status,which contains an until activity (Inside until i have wait activity and web activity which calls the same rest api to check the refresh status). I'm confused 2nd one gets suceeded whereas 1st one gets failed. All the input credentials provided are correct. Any Suggestions will be very helpful
Nandan Hegde 31,511 Reputation points MVP

2023-10-30T08:40:24.86+00:00

Hey, The reason why IF activity is executed because you have set On completion of web activity. So even if the Web activity is success or failure, the IF activity would be executed. Hope this clarifies

3 answers

Nandan Hegde 31,511 Reputation points MVP

2023-10-31T07:05:39.2833333+00:00

Glad @Devaraju Sankruth it got resolved.

As the Poster cannot accept his own answer, reposting your answer to close this thread :

The Web activity PowerBI dataset refresh failure seems to be a temporary / transient issue which seems to have been auto resolved.

And The reason why IF activity is executed because you have set On completion of web activity. So even if the Web activity is success or failure, the IF activity would be executed.
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment
ZoeHui-MSFT 35,556 Reputation points

2023-10-30T07:27:35.2333333+00:00

Hi @Devaraju Sankruth,

The issue is related with PBI Service, please raise the issue to PBI community to get professional advice.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Devaraju Sankruth 0 Reputation points

2023-10-31T07:01:37.8966667+00:00

Thanks @Nandan hegde for the response,
This issue got resolved after 24 hrs, i didnot make any changes. It may be temporary problem in accessing the powerbi dataset.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

PowerBi Dataset Refresh Failed With Error {"Message":"Request is blocked by the upstream service"} And Error Code: 2108

3 answers