Forum Discussion
Using .iqy file for import from SharePoint folder view
Hi, Anonymous I get the error " "We couldn't authenticate with the credentials provided" when entering following code: https://XX.sharepoint.com/teams/XX/_vti_bin/owssvr.dll?XMLDATA=1&List={LISTID}&View=CODEID Is there something wrong with URL code I try to generate?
Anonymous,
What authentication type do you use in Power BI Desktop? Do you use SharePoint Online or on-premises SharePoint?
Regards,
Lydia
Hi Lydia Anonymous, it is SharePoint Online
Anonymous,
What authentication type do you use in Power BI Desktop when connecting to the data source?
Regards,
LydiaHi Lydia Anonymous I use Organizational account, also tried Basic and Windows. When trying to access same Site with Get data-SharePoint list credentials work fine, so I wonder whether problem is with iqy code.