cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
polaris3028 Member
Member

Forbidden issue accessing Google Sheets

Hi Gurus,

 

Recently getting this error.

 

2018-07-20.png

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
polaris3028 Member
Member

Re: Forbidden issue accessing Google Sheets

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 2
Community Support Team
Community Support Team

Re: Forbidden issue accessing Google Sheets

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 Member
Member

Re: Forbidden issue accessing Google Sheets

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 270 members 2,842 guests
Please welcome our newest community members: