Get data from web - login needed

[Anonymous]

Hi,

This is a sort of bump from a couple of much older threads, curious if there are any solutions now we are in 2023.

I did a lot of searches on this but I didnt find much of a solution except for enabling Web Legacy mode in Excel which can do it.

Hopefully there is a way to do this in PBI now but I cannot find much recent.

Anyway, I have a table (csv file) in a webpage I need to pull into Power Query. The problem is you need to login to the webpage before you can access it. Is there anyway to do this in Power Query?

In a browser, I goto the page, and get directed to another to login, then I can get the page I need.

Report is here:
https://webpage.server.net/group123/QuickReport/Action/View/23236 (this is a csv file download)

Redirects to here until you login:
https://webpage.server.net/group123/

[ams1]

Hi,

Haven't clicked on the links you provided (safe habbit? 😁) - but I'm guessing that it's oauth related which is kinda challenging at least from Excel PowerQuery perspective (that doesn't support custom connectors - why Microsoft, WHY?!).

One of the main problems with implementing oauth in plain PowerQuery is the fact that you have to hardcode in the query your username and password (because you cannot EASILY use the credentials manager for that - WHY?!) which is NOT good practice.

see:

https://blog.crossjoin.co.uk/2021/08/29/connecting-to-rest-apis-with-oauth2-authentication-in-power-...

For PowerBI a custom connector can make oauth easier - but it's a bit more complicated to implement (not impossible).