Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Using .iqy file for import from SharePoint folder view

Hi,   I want to connect .iqy file (this file I get when clicking "Export to Excel" button in SharePoint Online) into PowerBi and enable background refresh and automatic refresh upon opening PowerBI...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

What authentication type do you use in Power BI Desktop when connecting to the data source?

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    Please use Fiddler to check if there are any details about the error.

    Regards,
    Lydia