Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper I
Helper I

Unable to get data from on-prem shareporint list

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:

BI Access.JPG

Helper I
Helper I


Hi @koshur,


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




Please respond?
Responsive Resident
Responsive Resident

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.


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


Annonmous.JPGorganizational account.JPGWin1.JPGwin2.JPG

Responsive Resident
Responsive Resident

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:


HTTPS did not work - unable to connect

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





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
    - abccorp
  3. On my iphone:
  4. Password: sample@123
    Domain: abccorp

    (all office emails come here)
  5. email:
  6. password:sample@123




Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors