Forum Discussion

row_01's avatar
row_01
New Member
9 years ago
Solved

Getting 404 error on web.contents request

I'm having trouble using PowerBI to read the contents of a new Yahoo Finance web page. Yahoo changed their layout for their earnings calendar page today, and now the query is returning a 404 error with the new URL. The URL loads fine in a browser but seemingly PowerBI is unable to read the contents. Any suggestions how to resolve this?

 

= Web.Page(Web.Contents("http://finance.yahoo.com/calendar/earnings"))

 

 

DataSource.Error: The remote server return an HTTP status code '404' when trying to access 'http://finance.yahoo.com/calendar/earnings/'.
Details:
DataSourceKind=Web
DataSourcePath=http://finance.yahoo.com/calendar/earnings
Url=http://finance.yahoo.com/calendar/earnings/

  • row_01

     

    It is a public webpage and Power BI can access it without problem in my test. Do you simply click "get data"->"other"->"web"? Can you try to create a new report and try to load that page?

     

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    row_01

     

    It is a public webpage and Power BI can access it without problem in my test. Do you simply click "get data"->"other"->"web"? Can you try to create a new report and try to load that page?

     

    • row_01's avatar
      row_01
      New Member

      Now it is working. I also re-opened my original workbook and refreshed the original query and it loaded this time. Not sure what was causing this - thank you for the quick reply.