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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Error: Excel connect Power Bl Datasets

Hi there,

 

This is to report an issue of Excel connecting Power BI dataset. Weeks ago, no such issue.

 

This week, I have been trying to connect to Power BI Datasets from Excel Desktop via "Data" > "Get Data" > "From Power BI (Spin Master Ltd)" to compose my own pivot table/report.

 

It is giving me an error that says:

 

====================================

Power Bl Datasets

 

An error occurred when trying to fetch list of datasets.

Unable to connect to Power BI to load your datasets. Please try again or contact Power BI support.

If you contact support, please provide these details.

 

FetchDatasets was unsuccessful

RequestiD: d113b226-7ca1-4fcb-8825-1fd2f32405c0

Status code: 400

Time: Thu, 21 Apr 2022 GMT

Version: 1.119.0

====================================

 

My Excel Online has the same issue when connecting Power BI Dataset.

 

Please help solve the issue.

 

Thanks,

tim

Status: Delivered

Hi @Anonymous ,

 

As showed in the Awareness section on Power BI Support website, the product group has been aware of this issue and the fix is expected to be deployed by the end of today(4/25/2022). Please be patient for the fix. Thanks for your understanding!

vcazhengmsft_0-1650851348727.png

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Delivered

Hi @Anonymous ,

 

As showed in the Awareness section on Power BI Support website, the product group has been aware of this issue and the fix is expected to be deployed by the end of today(4/25/2022). Please be patient for the fix. Thanks for your understanding!

vcazhengmsft_0-1650851348727.png

 

Best Regards,

Community Support Team _ Caiyun

Anonymous
Not applicable

now it's fixed. thanks a lot.

v-cazheng-msft
Community Support

Hi @Anonymous ,

 

That's great! Thanks for your confirmation!

 

Best Regards,

Community Support Team _ Caiyun

wilkstep
Advocate I

I'm still having the same issue.  I see the fix is supposed to be deployed by the end of the 25th.  I'll check again in the morning, but as of the moment, I'm still receiving the same error:

"FetchDatasets was unsuccessful
RequestID: Ob8720e5-295e-078d-bf33-f223130fcfdc
Status code: 400
Time: Tue, 26 Apr 2022 02:41:46 GMT
Version 1.119.0"