Forum Discussion
Web link can't open
Hi Team,
my client web link have user name and password , I have access to open in that website however I can't import data , it says front page like below, i have to go next page. please guide me.
Thanks,
KV's
2 Replies
- PhilipTreacy
Super User
Hi Anonymous
PBI can't interact with the login form shown in the Navigator. So it can't enter you usrname and pasword in those fields.
If the website you are trying to acces doesn't provide an API then you can look at using VBA to login to the site and get the data you need.
Further info
https://www.myonlinetraininghub.com/web-scraping-filling-forms
https://www.myonlinetraininghub.com/getting-started-with-apis-in-power-query
Regards
Phil
v-jingzhangCommunity Support
Hi Anonymous
Power BI is not able to deal with the login on your client web because this website doesn't open an API for Power BI. Maybe you can consider using other tools to pass the login process and download the data file automatically. Then connect to this downloaded file in Power BI Desktop.
For example, use Selenium webdriver to automate the downloading: https://stackoverflow.com/questions/33684136/automatic-download-file-from-web-page
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
