Forum Discussion
Extracting Data from a protected website
Hi Harpreet1405_12 ,
First, for the connection type, are you using Web? I am assuming so, but just confirming.
Second, based on your screenshot, I don't think that a URL will do the trick unless you have the full URL. This appears to be an embedded app and the output is based on the options that are selected. So, I don't think the url that we see in the screenshot will be the right URL. I am thinking that you would have to review the embedded bit and find the documentation for that program to determine if you can recreate the option selections in a URL. In my experience, it is easier to recreate the report in Power BI from the original data source than to try and get dynamic output from that report. Or, if you want a specific report that this is producing - can you have it automatically export it to a folder location or an email and then use that output?
hi collinq , I am using web and this URL has the web form created in asp.net language and this web form has multiple fields or drop downs , i am working on extracting all the tables , fields everything (historical data) by creating a live connection between them.
Hi Harpreet1405_12 ,
I think that the best method is going to get the data out of the system that is producing this web page. This is output from those tables and is put together but I think it would be very difficult to try and get the data out of what you are looking at based on the screenshot.
You will need to find the underlying tables (based on the screenshot - the ones in the SIS system itself) and then you can put together this report and other ones yourself quite easily since you will have the original data to link and create slicers from.
Thank you so much collinq for your time and response... Do you think excel would be the only option to maintain these tables in database?
Hey Harpreet1405_12 ,
Excel is a great tool for holding unstructured date (or exports of structured data) but it really shouldn't be considered a "database". I think your best bet is getting to the original data because that is going to the best maintained and current data.