Not able to connect to Sharepoint list using sharepoint online

[aqeel_shaikh]

Hi, Iam trying to connect to a sharepoint list using power BI > GetData > Sharepoint online --- using below sharepoint site. but unable to connect as iam getting below error.

I have clikced on anonymous as well.

[Anonymous]

Hi @aqeel_shaikh ,

So based on the URL pasted above, your datasoure is Sharepoint Online and not on-prem Sharepoint. Hence Sharepoint Online List connector needs to be used and not Sharepoint List. Which one is the customer using? Is it Sharepoint Online List connector or Sharepoint List?
Since this is Sharepoint Online we must use "Microsoft" authentication type, "Windows" authentication type should only be used if you were using Sharepoint On-Prem which is not the case here.

Best regards.
Community Support Team_Caitlyn

[aqeel_shaikh]

@Anonymous - it worked.

How it worked?
the file is saved on my org. sharepoint but instead of using sharepoint online, i tried using sharepoint list and it worked. Thanks for the help.

Much Appreciated 😊