Forum Discussion

Helper III

8 years ago

Solved

Forbidden issue accessing Google Sheets

Hi Gurus,

Recently getting this error.

Already tried republishing sheets, removing access and putting it back. Still not working. My account works with other sheets.

Any help will be appreciated.

Thanks,

Paul

polaris3028
8 years ago
Hi Maggie,

Thanks for your response. Further checked on this and it turned out that it only happens on shared google sheets. I created my own sheet and connect it to Power BI and it did work.

Thanks,
Paul

2 Replies

v-juanli-msft
Community Support
8 years ago
Hi polaris3028

I test on my site, create a google spreadsheet and publish it to web(meanwhile it generate a link), then I use the link to connect to in Power BI Desktop. Everything works well.

Could you paste your link in the web browser and open the page?

if you can't get proper contents this way, maybe the google sheets are restricted the access, so you can't connect to it using the anonymus credential, you need ask for the correct credential with author.

Best Regards

Maggie
- polaris3028
  Helper III
  8 years ago
  Hi Maggie,
  
  Thanks for your response. Further checked on this and it turned out that it only happens on shared google sheets. I created my own sheet and connect it to Power BI and it did work.
  
  Thanks,
  Paul

Related content