Forum Discussion
SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Value does not
Hi
I am getting the below error today. I am using SharePoint list
SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Value does not fall within the expected range.).
It worked fine yesterday, but stopped and sent an error log below
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Value does not fall within the expected range.)"}}],"exceptionCulprit":1}}} Table: HRD-EF-002 Mid-Year Review.
4 Replies
Anonymous , open in edit query mode, check if there are columns showing error. Try to debug as shown in videos
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTsI did, the error was in navigation, as soon as i select the SharePoint list this error pops up.
I am not able to add this list as a new data source it shows the same error "Re: SharePoint: Request failed: The remote server returned an error: (400) Bad Request."
it was running fine yesterday.
I'm using SharePoint lists as data Source and the Power BI account and SharePoint Account are the same.
Hi Anonymous ,
Do you use mashup data sources?
Refer:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hello. I'm also facing the same issue!
Did you find the answer? If yes, Can you please share the solution
Thank you
