Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Pulling data from a SharePoint site which uses custom authentication

(Note: Some details are vague on purpose)

Our organization has a certain SharePoint farm that utilizes a custom authentication application, which includes a redirect to a splash login page and redirect back the the SharePoint site.  It doesn't use Windows or Organizational authentication directly.  If I go to these SharePoint sites, go to a SharePoint list, and click "Export to Excel" I can setup the connectiong without any issues by running the downloaded .iqy file.  The OLEDB connection is made and upon each refresh, I get a popup with the custom authentication window which, once completed, closes and the refresh succeeds.


I have NOT been able to replicate this within PowerBI.  I have seen some community suggestions to simply take the URL that is within the .iqy file and use the web connector, but doing this does not ask me to authenticate, instead it simply pulls the HTML from the login splash window (which is obviously not helpful).


I need PowerBI's connector to work just like the Excel connector. I imagine I probably need to use the OLEDB connector? But I cannot figure out how to configure it.  The most important aspect here is that EXCEL can do it just fine..but I cannot figure out how to get PowerBI to do it.  If PowerBI could directly open a .iqy file (or .odc) and process it, I imagine this would be solved, but it cannot.


If anyone can provide some suggestions, or perhaps has done this before please provide some insights. Thank you!

Community Support
Community Support

Hi @lordneeko ,


You can try to create a cusotm connector.



Power BI Custom Data Connectors (Custom Authentication in ISV app) – tsmatz (

Connect to OData from Power BI using OAuth2 Authentication (




Best Regards,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.