Connect to Google Sheet to Power Pivot

Hi,

I would like to connect to Google Docs from Powerpivot, but I have no idea how I can do that.

I tried this:

New connection - From other sources - Data feed

But I can't make it to work, here's the error message I got:

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.

Any help is appreciated.

Thanks a lot!