title: PowerPivot - How to grab data from Yahoo webservices
body: <p>I would like to import weather forecasts in PowerPivot for a specified country by using Yahoo API.
  So first of all I got the data stream URL including all requiered parameters to get forecasts (it works in my browser).</p>
  
  <pre><code>https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20weather.forecast%20where%20woeid%3D612977&amp;format=json&amp;diagnostics=true&amp;callback=
  </code></pre>
  
  <p>Then I tried to use it as "Other data Stream" in PowerPivot to grab the content.
  However I got the following strange error about DTD :</p>
  
  <blockquote>
    <p>Cannot connect to the specified feed. Verify the connection and try
    again. Reason: For security reasons DTD is prohibited in this XML
    document. To enable DTD processing set the DtdProcessing property on
    XmlReaderSettings to Parse and pass the settings into XmlReader.Create
    method</p>
  </blockquote>
  
  <p>Any idea to solve that ?</p>