Forum Discussion

hitty08's avatar
hitty08
Regular Visitor
7 years ago

OData: Request failed (404)

I am trying to ingest and API from a sharepoint list using the Odata feature within PowerBI desktop. I continue to get Details: "OData: Request failed (404): The remote server returned an error: (...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi hitty08 ,

I still have a little confused about your scenario.

It seems that you want to get data from sharepoint list via OData connector in Power BI Desktop?

Do you connect SharePoint online list or SharePoint on- premises list in Power BI Desktop?And what URL do you use to connect to Sharepoint list?

Besides, based on my research,  the above error could occur when OData URL string is large or large number of columns are pulled into Power BI Desktop. Please check your URL and try to reduce columns, then check if the error goes away.

Best  Regards,

Cherry

 

hitty08's avatar
hitty08
Regular Visitor
7 years ago

I am connecting a list which is hosted by SharePoint on premise. I have built an API for the list using where I am ingesting the entire list.

https://link/sites/subsite/orgtest/listtest/_api/web/lists/GetByTitle('Demo List')/items

I am directly copying the link above into get

 

data --> Odata

 

The list only have 4 columns and 35 items total in each column. It is just a simple test list with nothing crazy on it.
Please let me know if you have any idea's