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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
kannanAhammed
Helper IV
Helper IV

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

 

Hi I am trying to connect to a sharepoint list, But i am getting the below error.

kannanAhammed_0-1594107247576.png

 

I have cleared the permissions but still the same problem. i have used to connect with sharepoint list and sharepoint online list but it still throws the same error.

 

I have created a list template from the same list (including contents) and created another list with it. it works fine. but for some reason it is not working with the original list, also i have unistalled and reinstalled the power Bi Desktop, still the issue is there.

 

I have even tried from a different system but sitll the same.

8 REPLIES 8
Jack_Henderson
Frequent Visitor

I had this same issue and took me a while to figure it out. 

Turns out if you have an apostrophe in the folder name or list name this will cause the issue, I assume this may be the same for other special characters. 
Once I removed the apostrophe all worked smoothly again!

Hope this can help others with this issue!

Big help! Thanks bud!

 

v-deddai1-msft
Community Support
Community Support

Hi @kannanAhammed ,

 

Would you please check the url you entered into when you connect to the sharepoint list. 

 

When connecting to a SharePoint list, enter the site URL instead of the list URL. In the Access SharePoint dialog box, select the most general URL to authenticate against the site correctly. By default, the most general URL is selected.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

URL i have seleced is the Sites, I was able to see and select the list.

trebgatte
Most Valuable Professional
Most Valuable Professional

I have a video of doing this at https://getstartedwithpowerbi.com

 

It might be helpful to see the happy path so that you can see where things might be going awry.

 

400 generally is a bad url in my experience though.

 

Hope this helps.

--Treb, MVP

https://marqueeinsights.com

The URL redircts me to https://marqueeinsights.com/get-started-with-power-bi/

when i copied and paised into the browser. 

The site shows some training meterials. i didnt see a video you have advised.

trebgatte
Most Valuable Professional
Most Valuable Professional

Thank you for the feedback. We'll have to label the videos better.

 

They are in the content blocks at the bottom of the page. The Data mining SharePoint Lists and Merging Excel Files articles with video show you the two basic techniques of working with SharePoint.

 

Hope this helps.

--Treb, MVP

https://marqueeinsights.com

The video you mentioned Shows how to connect to the SharePoint list, which is not relevant to my question here.

I am getting the below error while connecting to SharePoint list

"DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Value does not fall within the expected range.)
Details:"

 

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.