Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

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

 

Comments
mmuddasar
Advocate I

@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

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

ikechukwu
Employee

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