Forum Discussion

polaris3028's avatar
polaris3028
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 hel...
Need Help
  • polaris3028's avatar
    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

v-juanli-msft's avatar
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's avatar
    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