Forum Discussion
Using .iqy file for import from SharePoint folder view
Anonymous,
You can follow the steps below. You can check Guo_au's reply in this similar thread.
1.Open the iqy file with Notepad and copy the URL address, which includes names of list and view.
2.Open Web connector in Power BI Desktop.
3.Paste the URL link in web connector and then choose your table to import.
After creating reports in Power BI Desktop, you can publish the report to Power BI Service, and set schedule refresh for the dataset.
Regards,
Lydia
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,
LydiaHi Lydia Anonymous, it is SharePoint Online
Anonymous,
What authentication type do you use in Power BI Desktop when connecting to the data source?
Regards,
Lydia