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:
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
Thanks so much for any help you can provide!
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.