Power BI - Microsoft Copilot Connection Error

(4) Share

Report

Posted on by Vidisha

Hi, I am encountering connection issue in Microsoft Co-pilot Studio when trying to trigger the action that access dataset from Power BI. ERROR: "The connector ‘Power BI’ returned an HTTP error with code 400. Error code: ConnectorRequestFailure." Could please help in this.

Attaching error screenshot for reference.

Thanks in advance!!

Categories:

Calling actions from Copilot Studio

Error Screenshot.png

I have the same question (0)

All responses (8)

Answers (0)

VandanaaS 5 on at

Like (1)

Report

I am also facing similar issue. Can anyone please help in this. Thanks in advance!!

Was this reply helpful? Yes No
Louis McCoy 3 on at

Like (1)

Report

I am also experiencing this error. When I setup the Power BI connector and then change the first input to select a value, the list of workspaces I have access to is shown. I can either select the named workspace from the list or enter the group ID. The datasetid does not function this way. I have no list to select from and I get the error whether I enter the name or the guid of the dataset. It appears that the connector is not fully functional as of yet. It always fails with this error on the dataset lookup. I own the datasets I am testing and it shows my workspaces so permissions are not an issue.

Was this reply helpful? Yes No
CU03071620-0 2 on at

Like (1)

Report

Hi, I'm also facing the same issue. I've checked the Power BI website, and permissions are granted.

Error Message: The connector ‘Power BI’ returned an HTTP error with code 400.
Error Code: ConnectorRequestFailure
Conversation Id: 1f96bcff-0b40-4149-b86c-addc9e8a9717
Time (UTC): 2024-07-03T16:14:39.430Z

Could someone assist with resolving this?

Was this reply helpful? Yes No
Suggested answer

SpongYe 5,614 Super User 2025 Season 2 on at

Like (2)

Report

Hi @Vidisha,

1. Go to https://portal.azure.com/

2. Then search 'App registrations'

3. Select your copilot bot

4. Select 'API permissions' and then click 'add a permission'

5. Assign the Power BI Service permission to your bot.

That is what solved my problem.

Was this reply helpful? Yes No
Teteriachenko 6 on at

Like (0)

Report

I have same issue

And adding Power BI service to the API didn't help.

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

I had the following issue:

Check the API Limits:: The 400 error can sometimes be triggered by API limitations or throttling. Ensure you're not hitting the API limits for Power BI.

other checks: Check if the dataset is certified or promoted for easier access. Check the Microsoft 365 Service Health Dashboard to ensure there are no ongoing outages or issues with the Power BI service.

Was this reply helpful? Yes No
Suggested answer

Vinoth Selvam 1,590 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

have you tried the suggestion from SpongYe.

Issue must be due to API Perminssions.

Thanks.

Was this reply helpful? Yes No
Teteriachenko 6 on at

Like (0)

Report

Yes, we added Power BI Service to API of this Copilot. Here the screen

Was this reply helpful? Yes No