Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.