Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Hello. I'm also facing the same issue!
Did you find the answer? If yes, Can you please share the solution
Thank you
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.
@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
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.
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |