Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I am using an Excel power query which shows historical stock pricing data and I have Credential type public and I am trying to use a username and password for my yahoo account and I can't able to access it. I am getting an error message 301 response

1 Answer

0 votes
by (22.5k points)

Use the following functions

let
    Source = Web.Page(Web.Contents("https://finance.yahoo.com/quote/AAL/history?p=AAL", [Headers=[#"user-agent"="Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.86 Safari/537.36"]])),
    Data0 = Source{0}[Data]
in
    Data0

enter image description here

For more info on power bi, check the following  Power Bi course 

Related questions

0 votes
1 answer
asked Mar 23, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Feb 28, 2021 in BI by dev_sk2311 (45k points)
0 votes
1 answer
asked Feb 24, 2021 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...