Forum Discussion
Solved
Webscraping ASPX page: high difficulty
Hello community,
I was trying to use Power Query/Get and Transform to connect to an ASPX webpage and import from it the excel file given as output after fill in some forms.
After some searching, the only tutorial I found was from Huang Caiguang in his blog post (https://pqfans.com/207.html).
The problem seems to be the parameters as __EVENTTARGET, __VIEWSTATE, among others that are sent to the website containing the information about the forms.
Obs: There is no API available from this website.
Has anyone also tried to do something similar and that could share the solution/approach?
Thanks in advance!
I was trying to use Power Query/Get and Transform to connect to an ASPX webpage and import from it the excel file given as output after fill in some forms.
After some searching, the only tutorial I found was from Huang Caiguang in his blog post (https://pqfans.com/207.html).
The problem seems to be the parameters as __EVENTTARGET, __VIEWSTATE, among others that are sent to the website containing the information about the forms.
Obs: There is no API available from this website.
Has anyone also tried to do something similar and that could share the solution/approach?
Thanks in advance!
If web.page() function doesn't work, I would suggest you to use python script instead.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Have you tried webpage by example?
- Hello Matt,
Looking more carefully, it seems that what is needed is a custom connector, because there is a need to first log in the website, fill in some forms which loads another page with more forms, etc, until the excel folder is gives as output.
I think that the case in which no login is needed might be solved with the resource you indicated.If web.page() function doesn't work, I would suggest you to use python script instead.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
