Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Intermittent "Bad Request" errors when trying to refresh Dataset via API...

I have a program that automatically refreshes certain Datasets using the API. It has been running just fine for over a year, until I just added two Datasets whose source is a Sharepoint List. Up until then, all of my Datasets used SQL Server as their data soure. Since adding them, the attempt to refresh the Sharepoint Datasets has been failing on and off with the following error:


The remote server returned an error: (400) Bad Request.


At first, I thought it was a permanent issue with one of the Datasets and the solutions I attemtped appeared to solve the problem, but then the problem came back the next day, and it wasn't until I just let it ride for a while that I found out the error just randomly occurs. Sometimes it will work for both Datasets, sometimes it will fail for both Datasets, and sometimes it will only fail for one of the two Sharepoint Datasets. Sometimes it fails and then works again an hour later. Sometimes it fails for a few hours straight.


Does anyone know what might cause this and how to get rid of it?


Regular Visitor

Did you find a solution? I'm experiencing the same issue.

Super User IV
Super User IV

You could check the Issues forum here:

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors