(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!
