Unable to connect to Sharepoint List Datasource

[ProFe]

Hi everyone,

I'm using Powerbi desktop to connect to my Sharepoint site, and to 2 lists successfully.

I'm trying to connect to a third list, but I got an error :

DataSource.Error : Désolé... Nous n'avons pas pu analyser le résultat de la réponse OData. Erreur : A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected.
Détails :
    DataSourceKind=SharePoint
    DataSourcePath=https://xxxx.sharepoint.com/sites/Quality
    DataSourceKind.2=SharePoint

    DataSourcePath.2=https://xxxx.sharepoint.com/sites/Quality/_api/Web/Lists(guid'abfdac26-5e7b-4175-9417-355fb528f838')/Items

I can't have a preview of data, and of course can't connect and load data. 

I used to work with dozen of lists on this sharepoint site with success, I don't know this one is not working. I checked the fields, there is no Lookup or special columns.
Any help appreciated.

Thanks !

[ProFe]

I've reinstalled Powerbi, still not working. Any ideas of what could I try to find where the bugs come from?

[Anonymous]

Hi ProFe ,

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi.

[Anonymous]

Hi @ProFe ,

I am unable to reproduce your question at this time. Have you tried recreating the list and connecting again using Power BI Desktop? Make sure Power BI Desktop is the latest version.

[ProFe]

Hi @Anonymous ,

Thank you for your reply,

Unfortunately, I can't delete & recreate this list since I use it in many flows & powerapps, therefore it would break lot of things.
Power Bi Desktop is up to date, and it looks good with other lists.

I made a few research and it seems that this error message is often seen in power automate, when one mis-edit a lookup value.