cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phammk Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

I got the same error too

djeepy1 Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

You get a HTTP 400 error that indicates your request is incorrect (HTTP 400 Bad Request).

In error stack, I noticed :

 

     [..]DataSourcePath=http ://xxxx/_api/Web/Li%E2%80%8Bsts[..]

 

%E2, %80 and %8B are inserted in your URL. Can you check by typing your URL in a web browser ?

 

Jean-Pierre

Jean-Pierre Riehl
MVP Data Platform
lelenko Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

Can anyone give imformation on how we could do that?

lelenko Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

Hi,

can you please give any more specific information on how we could do that? Smiley Happy

kompas_ua Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

Hi lelenko,

 

What is your problem about? Do you struggle with extraction data from SPO list, which has a many lookup and multi-lookup fields? Here "many" means more then threshold.

 

BR, Sergey

kmccool Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

Thanks for the help. I went into the SahrePoint list and added and N/A choice then did quick edit to update all empty values to N/A and it worked!

 

Worth Noting:

We completely removed the column in the Power BI query and still got the error. We removed all null in the query editor and got the error as well. Only thing that worked was editing the column in SharePoint.

karo Regular Visitor
Regular Visitor

Re: Connecting to a SharePoint List Office 365 error

Any news regarding this error from the Microsoft side?

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 149 members 2,243 guests
Please welcome our newest community members: