SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Value does not

[kannanAhammed]

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.

[bhavana097]

Hello. I'm also facing the same issue!
Did you find the answer? If yes, Can you please share the solution 

Thank you 

[V-lianl-msft]

Hi @kannanAhammed ,

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.

[amitchandak]

@kannanAhammed , 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-Lag0VOiTs

[kannanAhammed]

I 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.