Back
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
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
For more info on power bi, check the following Power Bi course
31k questions
32.8k answers
501 comments
693 users