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: (404) Not Found. (Cannot find resource for the request $metadata.)"

Any idea's?

Need Help

2 Replies

  • 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