cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rbd318 Occasional Visitor
Occasional Visitor

SharePoint Online using wrong URL for record

I'm using the SharePoint Online List datasource to bring in data to Power BI.  This list includes a Manager2 column that has a data type of "Record", which I would like to expand to retrieve the Manager2 name.  When I try to view the record, however, I get a 404 error:

DataSource.NotFound: SharePoint: Request failed (404): The remote server returned an error: (404) Not Found. (Cannot find resource for the request OData_Manager2.)
Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://mycompany.sharepoint.com/sites/xxx/yyyyy/zzzzzzzzz
    SPRequestGuid=f39eba5d-c610-4398-bcfb-cc8d460d36a4
    Url=https://mycompany.sharepoint.com/sites/xxx/yyyyy/zzzzzzzzz/_api/Web/Lists(guid'02ca2098-5027-42e0-9570-d9941b18d62b')/Items(1)/OData_Manager2

When I look on the SharePoint List itself, the Manager column URL is named "Manager2" not "OData_Manager2".  When I use "Manager" at the end of the URL, I am able to retrieve the correct information:

 

https://mycompany.sharepoint.com/sites/xxx/yyyyy/zzzzzzzzz/_api/Web/Lists(guid'02ca2098-5027-42e0-9570-d9941b18d62b')/Items(1)/Manager2

 

The other fields in my report (e.g. "Manager") expand normally, so I think there is something wrong with this field specifically.  I've also tried accessing this list using the OData data source, and the behavior is identical.

 

I'm not sure if this is a Power BI issue or a SharePoint issue, but hopefully someone here can help me Smiley Happy

 

  1. Has anyone experienced similar issues before?
  2. Is there a way to override the record URL for a column (so that I could change it from "OData_Manager2" to "Manager2")
  3. Is there a way to fix this field mapping in SharePoint? (I understand if this is out of scope for this forum)

Thanks so much for any help you can provide!

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: SharePoint Online using wrong URL for record

@rbd318,

What is your Power BI Desktop version? What is data type of Manager2 column in SharePoint online? I will make a test to check if I can reproduce this issue.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.