Skip to main content
cancel
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

Reply
koshur
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

8 REPLIES 8
koshur
Helper I
Helper I

v-ljerr-msft
Employee
Employee

Hi @koshur,

 

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

 

 

Regards

Please respond?
hugoberry
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.

credentials.PNG

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

hugoberry
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:

\\sharedspaces\DavWWWRoot\somelibrary\document.xlsx 

HTTPS did not work - unable to connect

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

 

 

https.JPGdocs.JPG

documents.JPG

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

 

 

 

Helpful resources

Announcements
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