Forum Discussion

austin745's avatar
austin745
Regular Visitor
3 years ago

Browser in Power BI not updated for connecting google sheet

Good afternoon everyone. I am trying to connect to a Google sheet file online. I have already set the sheet to public sharing and when I try and connect with the Get Data->Web option it isn't working...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi austin745 

 

Windows 10 is ok. You may refer to the following blog to see if there is any step missed. 

Connect Google Sheets to Power BI: An Easy Guide (hevodata.com)

 

For the default web browser option in Power BI Desktop, please go to File > Options and settings > Options, then go to Security tab understand Global and select "Use my default web browser" option. 

 

Alternatively, you can try the Google Sheets connector in Power BI. It is generally available now. Power Query Google Sheets connector - Power Query | Microsoft Learn

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

austin745's avatar
austin745
Regular Visitor
3 years ago

Thank you for the response. The same problem is coming up with the default web browser option checked, so this does not appear to be the solution. As for the Google Sheets connector, it is not recognizing the web URL for the google sheet. I saw a guide somewhere that added something to the end of the URL to make the connector recognize the link, but I cannot remember what it was and there was some other error that came up anyways later. I look forward to any response on a further way to proceed.

 

-Austin