Unable to get data from on-prem shareporint list

[koshur]

I have a custom list in on-prem shareporint in office. When I try to connect via organizational account (my office account) I get the error:

[koshur]

Dear MOds,

Please move this under - http://community.powerbi.com/t5/Integrations-with-Files-and/bd-p/power-bi-services

[v-ljerr-msft]

Hi @koshur,

Have you tried using Window Authentication? Does it work with Window Authentication?

Regards

[koshur]

Please respond?

[hugoberry]

As @v-ljerr-msft has already been mentioned try using the Windows Authentication. You should be able to use your current credentials. If that fails try one of the credentials that you've mentioned.

[koshur]

Let me rephrase my point with screensots for all senarios. Nothing works! (FYI - i am the owner of this sharepoint site with full access)

[hugoberry]

Have you tried the HTTPS link instead?

Actually the problem might be with your SharePoint installation. Is it possible to check if your current user is added to the site? 

You might want to try to create a document in that sharepoint instance, and access the document via windows explorer. Then try to import the same document in Power BI by navigating to that shared location.

The shared location might look something like this:

\\sharedspaces\DavWWWRoot\somelibrary\document.xlsx 

[koshur]

HTTPS did not work - unable to connect

Uploaded a jpeg under documetns - I can't fetch this in BI either.

[koshur]

I tried, it doesnt work. Says unable to authenticate. SO here's what i have in office:

1. Domain user id (i use this to unlock my office windows laptop) - cdhbe2u9 *(ABCCorp/cdhbe2u9)
2. Password - sample@123
   Domain - abccorp
3. On my iphone: cdhbe2u9@abc.com
4. Password: sample@123
   Domain: abccorp
   
   (all office emails come here)
5. email: firstname.lastname@abc.com
6. password:sample@123