Import Data from an liste sharepoint (online ) into power bi desktop

[Adil2Hammad]

hi ,
Can Someone help me plz

when I try to connect Url that have data from List Sharepoint online with Power bi desktop
I found the error below :

Détails :  « OData : l'URL fournie ne pointe ni sur un service OData ni sur un flux : « https://collaboratif.cfdt.fr/lm_auth_proxy?DoLMLogin?curl=L2f_vti_binL2fL4cistDataL2esvc&curlid=7642... ».»

can you tell me why and how to Fix it ,

thank you in advance

[v-qiuyu-msft]

Hi @Adil2Hammad,

To get data from the online SharePoint list, you can use SharePoint Online List data source, enter the root URL of the SharePoint site. Assume the SharePoint list URL is https://microsoft.sharepoint.com/teams/Qiuyun01/Lists/List02/AllItems.aspx, the root URL should be https://microsoft.sharepoint.com/teams/Qiuyun01.

Best Regards,
Qiuyun Yu

[Adil2Hammad]

[v-qiuyu-msft]

Hi @Adil2Hammad,

Which Power BI Desktop did you run? Can you try this desktop version: 2.46.4732.461?

Also please use Fiddler to capture the trace when you get data in desktop, share the .saz here.

Best Regards,
Qiuyun Yu