Forum Discussion
Web scrapping
Hi, I am fetching data from the below website https://investors.att.com/~/media/Files/A/ATT-IR/financial-reports/quarterly-earnings/2020/q3-2020/Copy of 3Q20_Trending_Schedule.xlsx Now, what I want to do this, I want to create a function wherein if i select year as 2019, or quarter as 1,2,3,4 it should give me the result inside power query. Can this happen? Thanks,
3 Replies
Anonymous , Link is not opening. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Anonymous ,
I tried my best to Analyze the web page structure.The data is not saved in the web page or frame, it is downloaded through the pop-up window. I'm afraid we can't get the contents of the file dynamically through parameters.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Anonymous
The URL structure is not reliable to do what you want.
Whilst this URL retrieves a file
This does not
Even though I've changed the 2nd URL to reflect what you'd hope the URL woudl be for Q1 202 rather than Q4.
Regards
Phil
