Connect .iqy file to Power Bi Desktop

[irina_berlin]

Hi,

I want to connect .iqy file (export from a view af a library in SharePoint Online) into PowerBi to make evaluations with live data. Whatever I do, I get the error "We couldn't authenticate with the credentials provided". Please help me to solve this problem. I've seen similar posts like here, here and here.  Moreover I could connect an .iqy file from SP 2013 to PowerBi two years ago. But now - I neither can repeat the connection with SP2013, nor create a new one from SP Online library.  

- my account works well when accessing SP Online sites at the same time

- I use web connector

- I tried to access web content with organizational account, basic and windows - using my working credetials, but I get the same error. When using organizational account I get the most "funny" error: "Current user isn't signed in. You are already signed in." !!!

- I tried all offered url-levels: https://mycompany.sharepoint.com/sites,   https://mycompany.sharepoint.com/sites/TeamSite_XXX    and https://mycompany.sharepoint.com/sites/TeamSite_XXX/_vti_bin     

Please help! What modifications should I?

WEB
1
https://mycompany.sharepoint.com/sites/TeamSite_XXX/_vti_bin/owssvr.dll?XMLDATA=1&List=ListID&View=V...  

Selection=ListID-ViewID
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication= https://mycompany.sharepoint.com/sites/TeamSite_XXX/_vti_bin   
SharePointListView=ViewID
SharePointListName=ListID
RootFolder=

Regards

[Anonymous]

Hi @irina_berlin ,

There is a similar thread here,the reason is that Web.BrowserContent() does not support the organization's authentication type. The new WEB connector uses it by default.

Solved: Re: Web.BrowserContents only supports anonymous et... - Microsoft Power BI Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[irina_berlin]

Hi Gao,

thanx a lot for the reply! Referreing to this solution 

1. I've understood the problem 

2. I've tested the approach 2: Consider Using Web.Page instead of Web.BrowserContents. -->unfortunately, it didn't work. I think, the reason is the note saying: "Currently, you can't turn off the use of Web.BrowserContents in Power BI Desktop optimized for Power BI Report Server."  (Which version of Power BI Desktop is optimized?)

3. I cannot use the Sharepoint folder connector, as my library has more than 12 look-up columns. So my workaround is/was to comprise the library in several views and export each of them to an .iqy -file. Finally I wanted to connect each .iqy-file to the  PowerBi Desctor to make evaluations. If you know an another workaround for libraries with more than 12 look- up columns, please help :). 

4. I tested the way SP Online library-->Integrate-->PowerBi-->Vizualizations. But it cannot be included into a page and the most impoortant - it doesn't show all existant columns of the library, just a part of them. I didn't find the way how to choose the columns.  Additionally I need an another data source connected to the library data, so it is not possible too (as I understand).

Best regards

Irina