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

I have the same question (0)

All responses (8)

Answers (0)

VandanaaS 5 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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,715 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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,592 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No