Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Thanks so much for any help you can provide!
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.