Linking Workbook to CSV file from Yahoo Finance

Anonymous · ‎12-17-2018

I am trying to connect a workbook to a CSV file from the web (yahoo finance, stock prices). The link is below:

When I try to connect to it with the query editor, it shows "we couldn't authenticate with the credentials provided. Please try again."

My steps are

1. Copy CSV link from Yahoo Finance

2. Go to "get data from web"

3. Paste link using the basic editor

4. Access web content anonymously

5. Connect

Is there anything I need to change in my steps? And has anyone else connected to a CSV from Yahoo Finance?

Thank you for any help on this!

Anonymous · ‎12-17-2018

@Anonymous,

Please follow the guide in the blog below to import data from CSV file to Power BI Desktop.

https://powerbidatamodel.com/powerbi/how-to-connect-to-yahoo-finance-using-power-bi/

Regards,
Lydia

Helpful resources