Forum Discussion
Google Sheets (highly sensetive data shared within company)
Olia,
You can connect to Google sheets using R or custom connector in Power BI Desktop. Both methods require authentication, which builds a secure channel between Google sheet and Power BI. For more details, please review the following blog.
https://itsalocke.com/blog/connect-to-google-sheets-in-power-bi-using-r/
https://www.thebiccountant.com/2017/09/24/custom-connector-import-google-sheets-oauth2-powerbi/
In addition, could you please describe more details about why you want users to refresh the data? You can publish the PBIX file to Power BI Service and then use gateway to refresh dataset, and you can share the report to users, they can get updated data in the report based on refresh schedule you set.
Regards,
Lydia
Hi Lydia Anonymous
Have you tried creating the connector yourself? Because I'm stuck at OAuth Consent Screen. what is this Authorized domain they are talking about? and I don't see exactly how you can set it up in such a way that only a number of previously approved people can see the data.
As for your question, there will be no support for the PBI report created from my side. every Sales person must be able to edit the underlying dataset on google sheets, and update the report for themselves. After all, I don't think that my manager will be happy if I get access to how much my colleagues are earning.
Thank you for everything
GamesBXOlia，
Could you please post a screenshot and error message? Another easy method is to connect to Google Sheet data following the guide in this thread.
After publishing the PBIX file to Power BI Service and set schedule refresh for the dataset, when users edit the underlying data in google sheet, Power BI report will get updated automatically.
Regards,
Lydia
