How to import data from password protected website ?

[Rahul_SC]

Hi all,

Is it possible to import data into power BI from a password protected website ? If yes, let me know.

Connecting to public url is easy into power bi using web option. In the basic option, I see username and password to connect with the data. But it does not work. Any help would be appreciated. 

Thanks!

[Johns23]

Importing data from a password-protected website into Power BI is indeed possible using the web connector.
If you're encountering issues with the basic authentication method, you might explore other options like OAuth2 or API-based connections if the website provides those alternatives

[Rahul_SC]

Hi @mussaenda ,

Thanks for responding. I used this site for just an example. Let's say we have any other website subscribtion for which I always login by username and password that data I want to import in power bi.

any help for this ?

[mussaenda · Accepted solution]

Dear @Rahul_SC ,

I found one answer from this community

I am sharing the link

https://community.powerbi.com/t5/Desktop/Connect-to-web-data-via-login/m-p/1841000 

Hope this helps.

[mussaenda]

Dear @Rahul_SC,

We are also using the searates site but not using the login details.

Better if you can do using their API.

Hope this helps