Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

asjones

Excel - Getting PowerB DataSets "An error occurred when trying to fetchlist of datasets" - E

Submitted by Helper IV on ‎04-15-2022 10:37 AM

In Excel 365, this worked a week ago.... When I go to Get Data -> From Power BI

 

A sidebar error message comes up "Power BI Datasets" . An error occurred when tryign to fetch list of datasets. Unable to connect to Power BI to load your datasts. Please try again orcontact Power BI support.

 

Detials:

FetchDatasets was unsuccessfull.

RequestID: c4b3d200-a7e7-b431-9084-07c90d8d0e20

Status code 400

Time: Fri, 15 Apr 2022 17:32:45 GMT

Version 1.119.0

 

Status: Delivered

Hi @asjones ,

 

This has been acknowledged as a Power BI Known issue, and engineers will fix this in the future.
As a workaround：

Customer can navigate to the Power BI datasets hub and search for the dataset they need to connect to and click Analyze in Excel to generate an Excel workbook connected to the Power BI dataset.

 

Best Regards,
Community Support Team _ Caitlyn

 

See more ideas labeled with:
33 Comments (33 New)
Comments
mmuddasar
Advocate I
Advocate I
‎07-06-2022 08:43 AM

@ikechukwu Thanks. Can I raise it through Power Platform Admin Center support request or should I use the Feedback option in Excel itself? (Power Platform ticket doesn't allow me to select Excel as the product I'm having trouble with).

ikechukwu
Employee
Employee
‎07-06-2022 08:52 AM

@mmuddasar Use both and specifically mention my name so it can be routed to my team should the ticket get "lost".

ikechukwu
Employee
Employee
‎07-06-2022 09:00 AM

@mmuddasar Please provide Fiddler traces as part of the ticket.

Idea Statuses