cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gemidriver Helper II
Helper II

Connect to Sharepoint List OnPremise - ADFS auth

i am trying to connect to our on premise sharepoint

i enter my URL as follows

https://sharepoint.domain.com.au/Site

i try my FQDN credentials and get Access to the resource is forbidden

 

we use ADFS authentication to access Sharepoint, what can i do to connect?

5 REPLIES 5
SimonJF
Frequent Visitor

Re: Connect to Sharepoint List OnPremise - ADFS auth

I believe this is a known issue - pretty sure this work around will achieve what you want to do:

 

Assumption 1: You are trying to connect to a Document Library

Select from Home Tab: Get Data > Blank Query

Click: Advanced Editor

Replace the default code with the below - obviously putting in your real url 🙂

This should then prompt you with a authentication dialog

After this you should be able to navigate the directory structure to the relevant Document Library.

 

 

let
  Source = SharePoint.Contents("https://sharepoint.domain.com.au/Site", [ApiVersion = 14])
in
  Source

 

 

 

Assumption 2: You are trying to access a SharePoint List

let
  Source = SharePoint.Tables("https://sharepoint.domain.com.au/Site", [ApiVersion = 14])
in
  Source
gemidriver Helper II
Helper II

Re: Connect to Sharepoint List OnPremise - ADFS auth

i tried both methods with various credentials and get the same results

Access to the resource is forbidden

Moderator v-yuezhe-msft
Moderator

Re: Connect to Sharepoint List OnPremise - ADFS auth

@gemidriver,

Have you enabled Windows auth in your data source? Generally, we use Windows authentication to connect to on-premises SharePoint in Power BI Desktop.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gemidriver Helper II
Helper II

Re: Connect to Sharepoint List OnPremise - ADFS auth

we use ADFS to authenticate to our on prem sharepoint site

 

Highlighted
BeenSearching
Frequent Visitor

Re: Connect to Sharepoint List OnPremise - ADFS auth

 


@gemidriver wrote:

we use ADFS to authenticate to our on prem sharepoint site

 


We haven't found a way to authenticate using ADFS. The only way we've found to connect so far uses IWA.

 

Have you found a solution yet? 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors