Forum Discussion
How to connect to Google Sheet via new Sheet API - Blog post
In case you are interested, here's my latest blog post on pulling data from Google Sheet using the Sheet API. https://tumbleroad.com/2016/07/07/free-marquee-google-sheets-template/
I had tested against a private Google sheet so it should work. I'll have to look at this again over the weekend.
Treb Gatte | Business Solutions MVP/Power BI Partner | Power BI Recordings | @tgatte | Blog
When using my own spreadsheet and API key (set up using the instructions on your site), I get a "PERMISSION_DENIED" result when accessing the link. I think this is why my data is failing.
However, using your link (the commented out link in the Power BI script) your data and API key are loading the data correctly.
Are there any other settings you made when setting up the API key? That is probably why mine isn't working.