oData expand record error

[Anonymous]

I have report using SharePoint list as source (oData connection) One of the fields is "record" data type When yoou "split" the record and chose only one of the record subset (title), there is a new error

DataSource.NotFound: SharePoint: Request failed (404): The remote server returned an error: (404) Not Found. (Item does not exist. It may have been deleted by another user.) Details: DataSourceKind=SharePoi

It has been working Power BI desktop (June 2018), last two are not working. Steps:

1- Connect to SharePoint

2- Expand "record" field"

3- Keep only Title Column

4- Close and Apply

5- Boom...another new error in Power BI after update to last version

Regards Rodrigo

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[Anonymous]

It is not working...I will check with December version.

[v-jiascu-msft]

Hi Rodrigo,

Why not using the Sharepoint list connector? Please refer to the snapshot below. I would also suggest you upgrade the Desktop to the latest version.

Best Regards,
Dale