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

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

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

Check it Out!

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

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!